git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit

Add pg_sequence system catalog

author Peter Eisentraut <peter_e@gmx.net>

2016年12月20日 17:00:00 +0000 (12:00 -0500)

committer Peter Eisentraut <peter_e@gmx.net>

2016年12月20日 13:28:18 +0000 (08:28 -0500)

commit 1753b1b027035029c2a2a1649065762fafbf63f3

tree cd5b4d8fca4ffca2581e3822a2fa7b5f2f49062a tree

parent db80acfc9d50ac56811d22802ab3d822ab313055 commit | 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 | blame | history

src/backend/catalog/Makefile diff | blob | blame | history

src/backend/catalog/dependency.c diff | blob | blame | history

src/backend/catalog/information_schema.sql diff | blob | blame | history

src/backend/catalog/system_views.sql diff | blob | blame | history

src/backend/commands/sequence.c diff | blob | blame | history

src/backend/utils/cache/syscache.c diff | blob | blame | history

src/bin/pg_dump/pg_dump.c diff | blob | blame | history

src/include/catalog/catversion.h diff | blob | blame | history

src/include/catalog/indexing.h diff | blob | blame | history

src/include/catalog/pg_sequence.h [new file with mode: 0644] blob