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