]> granicus.if.org Git - postgresql/commit
Implement remaining fields of information_schema.sequences view
authorPeter Eisentraut <peter_e@gmx.net>
Sun, 2 Jan 2011 13:08:08 +0000 (15:08 +0200)
committerPeter Eisentraut <peter_e@gmx.net>
Sun, 2 Jan 2011 13:15:21 +0000 (15:15 +0200)
commit39b88432968a2f4c01c20948f12bf9c8e388474d
treec79c81d964ef5a1caf6783ebda8ecfbf345d8006
parente657b55e661577cf664949bce78068e2922f594f
Implement remaining fields of information_schema.sequences view

Add new function pg_sequence_parameters that returns a sequence's start,
minimum, maximum, increment, and cycle values, and use that in the view.
(bug #5662; design suggestion by Tom Lane)

Also slightly adjust the view's column order and permissions after review of
SQL standard.
doc/src/sgml/information_schema.sgml
src/backend/catalog/information_schema.sql
src/backend/commands/sequence.c
src/include/catalog/catversion.h
src/include/catalog/pg_proc.h
src/include/commands/sequence.h
src/test/regress/expected/sequence.out
src/test/regress/sql/sequence.sql