Add pg_sequence system catalog
Peter Eisentraut <peter_e@gmx.net>
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>
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/catalogs.sgml | modified | +87 −1 |
| src/backend/catalog/dependency.c | modified | +6 −0 |
| src/backend/catalog/information_schema.sql | modified | +7 −6 |
| src/backend/catalog/Makefile | modified | +1 −0 |
| src/backend/catalog/system_views.sql | modified | +8 −8 |
| src/backend/commands/sequence.c | modified | +216 −165 |
| src/backend/utils/cache/syscache.c | modified | +12 −0 |
| src/bin/pg_dump/pg_dump.c | modified | +21 −1 |
| src/include/catalog/catversion.h | modified | +1 −1 |
| src/include/catalog/indexing.h | modified | +3 −0 |
| src/include/catalog/pg_sequence.h | added | +30 −0 |
| src/include/commands/sequence.h | modified | +8 −21 |
| src/include/utils/syscache.h | modified | +1 −0 |
| src/test/regress/expected/rules.out | modified | +9 −9 |
| src/test/regress/expected/sanity_check.out | modified | +1 −0 |
| src/test/regress/expected/sequence.out | modified | +27 −6 |
| src/test/regress/expected/updatable_views.out | modified | +43 −50 |
| src/test/regress/sql/sequence.sql | modified | +8 −0 |
| src/test/regress/sql/updatable_views.sql | modified | +1 −1 |