pgsql: Add pg_sequence system catalog

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add pg_sequence system catalog
Date: 2016-12-20 13:42:53
Message-ID: E1cJKgv-0004eC-KE@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

Add pg_sequence system catalog

Move sequence metadata (start, increment, etc.) into a proper system
catalog instead of storing it in the sequence heap object. This
separates the metadata from the sequence data. Sequence metadata is now
operated on transactionally by DDL commands, whereas previously
rollbacks of sequence-related DDL commands would be ignored.

Reviewed-by: Andreas Karlsson <andreas(at)proxel(dot)se>

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/1753b1b027035029c2a2a1649065762fafbf63f3

Modified Files
--------------
doc/src/sgml/catalogs.sgml | 88 +++++-
src/backend/catalog/Makefile | 1 +
src/backend/catalog/dependency.c | 6 +
src/backend/catalog/information_schema.sql | 13 +-
src/backend/catalog/system_views.sql | 16 +-
src/backend/commands/sequence.c | 381 +++++++++++++++-----------
src/backend/utils/cache/syscache.c | 12 +
src/bin/pg_dump/pg_dump.c | 22 +-
src/include/catalog/catversion.h | 2 +-
src/include/catalog/indexing.h | 3 +
src/include/catalog/pg_sequence.h | 30 ++
src/include/commands/sequence.h | 29 +-
src/include/utils/syscache.h | 1 +
src/test/regress/expected/rules.out | 18 +-
src/test/regress/expected/sanity_check.out | 1 +
src/test/regress/expected/sequence.out | 33 ++-
src/test/regress/expected/updatable_views.out | 93 +++----
src/test/regress/sql/sequence.sql | 8 +
src/test/regress/sql/updatable_views.sql | 2 +-
19 files changed, 490 insertions(+), 269 deletions(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2016-12-20 14:59:19 Re: pgsql: Add pg_sequence system catalog
Previous Message Heikki Linnakangas 2016-12-20 07:23:42 pgsql: Fix sharing Agg transition state of DISTINCT or ordered aggs.

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2016-12-20 13:44:15 Re: Time to drop old-style (V0) functions?
Previous Message Robert Haas 2016-12-20 13:41:51 Re: Hash Indexes