Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-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

pgsql-hackers by date

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

pgsql-committers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group