pgsql: Implement remaining fields of information_schema.sequences view

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Implement remaining fields of information_schema.sequences view
Date: 2011-01-02 13:16:35
Message-ID: E1PZNnX-0003tN-Hg@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

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

Browse pgsql-committers by date

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

Browse pgsql-hackers by date

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