]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Replicate generated columns when 'publish_generated_columns' is set.
authorAmit Kapila <akapila@postgresql.org>
Thu, 7 Nov 2024 03:28:49 +0000 (08:58 +0530)
committerAmit Kapila <akapila@postgresql.org>
Thu, 7 Nov 2024 03:28:49 +0000 (08:58 +0530)
commit7054186c4ebe24e63254651e2ae9b36efae90d4e
tree56f43479b5f7c127128b91697da9db84242bc67e
parent70291a3c66eca599fd9f59f7f6051432b2020f4b
Replicate generated columns when 'publish_generated_columns' is set.

This patch builds on the work done in commit 745217a051 by enabling the
replication of generated columns alongside regular column changes through
a new publication parameter: publish_generated_columns.

Example usage:
CREATE PUBLICATION pub1 FOR TABLE tab_gencol WITH (publish_generated_columns = true);

The column list takes precedence. If the generated columns are specified
in the column list, they will be replicated even if
'publish_generated_columns' is set to false. Conversely, if generated
columns are not included in the column list (assuming the user specifies a
column list), they will not be replicated even if
'publish_generated_columns' is true.

Author: Vignesh C, Shubham Khanna
Reviewed-by: Peter Smith, Amit Kapila, Hayato Kuroda, Shlok Kyal, Ajin Cherian, Hou Zhijie, Masahiko Sawada
Discussion: https://postgr.es/m/B80D17B2-2C8E-4C7D-87F2-E5B4BE3C069E@gmail.com
20 files changed:
doc/src/sgml/ddl.sgml
doc/src/sgml/protocol.sgml
doc/src/sgml/ref/create_publication.sgml
src/backend/catalog/pg_publication.c
src/backend/commands/publicationcmds.c
src/backend/replication/logical/proto.c
src/backend/replication/pgoutput/pgoutput.c
src/bin/pg_dump/pg_dump.c
src/bin/pg_dump/pg_dump.h
src/bin/pg_dump/t/002_pg_dump.pl
src/bin/psql/describe.c
src/bin/psql/tab-complete.in.c
src/include/catalog/catversion.h
src/include/catalog/pg_publication.h
src/include/replication/logicalproto.h
src/test/regress/expected/psql.out
src/test/regress/expected/publication.out
src/test/regress/sql/publication.sql
src/test/subscription/t/011_generated.pl
src/test/subscription/t/031_column_list.pl