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

Responses

• Re: [COMMITTERS] pgsql: Implement remaining fields of information_schema.sequences view at 2011-01-07 17:37:35 from Chris Browne

pgsql-hackers by date

Next:	From: Peter Eisentraut	Date: 2011-01-02 13:17:18
	Subject: Re: [BUGS] BUG #5662: Incomplete view
Previous:	From: KaiGai Kohei	Date: 2011-01-02 12:54:18
	Subject: Re: management of large patches

pgsql-committers by date

Next:	From: Magnus Hagander	Date: 2011-01-03 09:45:47
	Subject: pgsql: perltidy run on the MSVC build system
Previous:	From: Robert Haas	Date: 2011-01-02 12:26:43
	Subject: Re: [COMMITTERS] pgsql: Basic foreign table support.