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(-)