pgsql: Support adding partitioned tables to publication

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема pgsql: Support adding partitioned tables to publication
Дата
Msg-id E1jBa0j-0005mh-8X@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Support adding partitioned tables to publication

When a partitioned table is added to a publication, changes of all of
its partitions (current or future) are published via that publication.

This change only affects which tables a publication considers as its
members.  The receiving side still sees the data coming from the
individual leaf partitions.  So existing restrictions that partition
hierarchies can only be replicated one-to-one are not changed by this.

Author: Amit Langote <amitlangote09@gmail.com>
Reviewed-by: Rafia Sabih <rafia.pghackers@gmail.com>
Reviewed-by: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Discussion:
https://www.postgresql.org/message-id/flat/CA+HiwqH=Y85vRK3mOdjEkqFK+E=ST=eQiHdpj43L=_eJMOOznQ@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/17b9e7f9fe238eeb5f6b40061b444ebf28d9e06f

Modified Files
--------------
doc/src/sgml/logical-replication.sgml       |  17 +--
doc/src/sgml/ref/create_publication.sgml    |  19 ++-
src/backend/catalog/pg_publication.c        |  85 ++++++++++---
src/backend/commands/publicationcmds.c      |  23 +++-
src/backend/replication/logical/tablesync.c |   1 +
src/backend/replication/pgoutput/pgoutput.c |  19 ++-
src/bin/pg_dump/pg_dump.c                   |   8 +-
src/include/catalog/pg_publication.h        |  19 ++-
src/test/regress/expected/publication.out   |  34 +++++-
src/test/regress/sql/publication.sql        |  23 +++-
src/test/subscription/t/013_partition.pl    | 178 ++++++++++++++++++++++++++++
11 files changed, 382 insertions(+), 44 deletions(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: pgsql: Prevent reindex of invalid indexes on TOAST tables
Следующее
От: Peter Eisentraut
Дата:
Сообщение: pgsql: Remove utils/acl.h from catalog/objectaddress.h