diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2016-12-20 12:00:00 -0500 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2016-12-20 08:28:18 -0500 |
| commit | 1753b1b027035029c2a2a1649065762fafbf63f3 (patch) | |
| tree | cd5b4d8fca4ffca2581e3822a2fa7b5f2f49062a /src/backend/utils/cache/syscache.c | |
| parent | db80acfc9d50ac56811d22802ab3d822ab313055 (diff) | |
| download | postgresql-1753b1b027035029c2a2a1649065762fafbf63f3.tar.gz postgresql-1753b1b027035029c2a2a1649065762fafbf63f3.zip | |
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>
Diffstat (limited to 'src/backend/utils/cache/syscache.c')
| -rw-r--r-- | src/backend/utils/cache/syscache.c | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/src/backend/utils/cache/syscache.c b/src/backend/utils/cache/syscache.c index a3e0517b940..e87fe0ef548 100644 --- a/src/backend/utils/cache/syscache.c +++ b/src/backend/utils/cache/syscache.c @@ -53,6 +53,7 @@ #include "catalog/pg_range.h" #include "catalog/pg_rewrite.h" #include "catalog/pg_seclabel.h" +#include "catalog/pg_sequence.h" #include "catalog/pg_shdepend.h" #include "catalog/pg_shdescription.h" #include "catalog/pg_shseclabel.h" @@ -668,6 +669,17 @@ static const struct cachedesc cacheinfo[] = { }, 8 }, + {SequenceRelationId, /* SEQRELID */ + SequenceRelidIndexId, + 1, + { + Anum_pg_sequence_seqrelid, + 0, + 0, + 0 + }, + 32 + }, {StatisticRelationId, /* STATRELATTINH */ StatisticRelidAttnumInhIndexId, 3, |