]> granicus.if.org Git - postgresql/commit
projects / postgresql / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: db80acf) | patch
Add pg_sequence system catalog
authorPeter Eisentraut <peter_e@gmx.net>
Tue, 20 Dec 2016 17:00:00 +0000 (12:00 -0500)
committerPeter Eisentraut <peter_e@gmx.net>
Tue, 20 Dec 2016 13:28:18 +0000 (08:28 -0500)
commit1753b1b027035029c2a2a1649065762fafbf63f3
treecd5b4d8fca4ffca2581e3822a2fa7b5f2f49062atree | snapshot
parentdb80acfc9d50ac56811d22802ab3d822ab313055commit | diff
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@proxel.se>
19 files changed:
doc/src/sgml/catalogs.sgml diff | blob | history
src/backend/catalog/Makefile diff | blob | history
src/backend/catalog/dependency.c diff | blob | history
src/backend/catalog/information_schema.sql diff | blob | history
src/backend/catalog/system_views.sql diff | blob | history
src/backend/commands/sequence.c diff | blob | history
src/backend/utils/cache/syscache.c diff | blob | history
src/bin/pg_dump/pg_dump.c diff | blob | history
src/include/catalog/catversion.h diff | blob | history
src/include/catalog/indexing.h diff | blob | history
src/include/catalog/pg_sequence.h [new file with mode: 0644] blob
src/include/commands/sequence.h diff | blob | history
src/include/utils/syscache.h diff | blob | history
src/test/regress/expected/rules.out diff | blob | history
src/test/regress/expected/sanity_check.out diff | blob | history
src/test/regress/expected/sequence.out diff | blob | history
src/test/regress/expected/updatable_views.out diff | blob | history
src/test/regress/sql/sequence.sql diff | blob | history
src/test/regress/sql/updatable_views.sql diff | blob | history
Unnamed repository; edit this file 'description' to name the repository.