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. Branch ------ master Details ------- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=39b88432968a2f4c01c20948f12bf9c8e388474d Modified Files -------------- doc/src/sgml/information_schema.sgml | 27 ++++++++++---- src/backend/catalog/information_schema.sql | 12 ++++--- src/backend/commands/sequence.c | 51 ++++++++++++++++++++++++++++ src/include/catalog/catversion.h | 2 +- src/include/catalog/pg_proc.h | 2 + src/include/commands/sequence.h | 2 + src/test/regress/expected/sequence.out | 7 ++++ src/test/regress/sql/sequence.sql | 3 ++ 8 files changed, 92 insertions(+), 14 deletions(-) -- Sent via pgsql-committers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
