[COMMITTERS] pgsql: Add pg_sequence system catalog

Поиск
Список
Период
Сортировка
Искать
От
Peter Eisentraut
Тема
[COMMITTERS] pgsql: Add pg_sequence system catalog
Дата
Msg-id
E1cJKgv-0004eC-KE@gemulon.postgresql.org
Список
Дерево обсуждения
[COMMITTERS] pgsql: Add pg_sequence system catalog Peter Eisentraut <peter_e@gmx.net>
Re: [COMMITTERS] pgsql: Add pg_sequence system catalog Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [COMMITTERS] pgsql: Add pg_sequence system catalog Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [COMMITTERS] pgsql: Add pg_sequence system catalog Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [COMMITTERS] pgsql: Add pg_sequence system catalog Tom Lane <tgl@sss.pgh.pa.us>
Re: [COMMITTERS] pgsql: Add pg_sequence system catalog Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
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 

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(-)

В списке pgsql-committers по дате отправления
От: Heikki Linnakangas
Дата:
От: Peter Eisentraut
Дата:
FAQ