diff options
| author | Amit Kapila <akapila@postgresql.org> | 2022-09-07 08:46:32 +0530 |
|---|---|---|
| committer | Amit Kapila <akapila@postgresql.org> | 2022-09-07 08:46:32 +0530 |
| commit | 25996a82a44629bdedeae73b36c37ee35b37e9fe (patch) | |
| tree | e23c70ae337b5c7acaba8aa1e1ea575dcdf3df99 /doc/src/sgml/ref | |
| parent | e25631265a233e0c315458b206e419eca69fdb22 (diff) | |
Doc: Explain about Column List feature.
Add a new logical replication section for "Column Lists" (analogous to the
Row Filters page). This explains how the feature can be used and the
caveats in it.
Author: Peter Smith
Reviewed-by: Shi yu, Vignesh C, Erik Rijkers, Amit Kapila
Backpatch-through: 15, where it was introduced
Discussion: https://postgr.es/m/CAHut+PvOuc9=_4TbASc5=VUqh16UWtFO3GzcKQK_5m1hrW3vqg@mail.gmail.com
Diffstat (limited to 'doc/src/sgml/ref')
| -rw-r--r-- | doc/src/sgml/ref/alter_publication.sgml | 12 | ||||
| -rw-r--r-- | doc/src/sgml/ref/create_publication.sgml | 6 |
2 files changed, 7 insertions, 11 deletions
diff --git a/doc/src/sgml/ref/alter_publication.sgml b/doc/src/sgml/ref/alter_publication.sgml index 3a74973da01..d8ed89ee917 100644 --- a/doc/src/sgml/ref/alter_publication.sgml +++ b/doc/src/sgml/ref/alter_publication.sgml @@ -118,15 +118,9 @@ ALTER PUBLICATION <replaceable class="parameter">name</replaceable> RENAME TO <r Optionally, a column list can be specified. See <xref linkend="sql-createpublication"/> for details. Note that a subscription having several publications in which the same table has been published - with different column lists is not supported. So, changing the column - lists of the tables being subscribed could cause inconsistency of column - lists among publications, in which case <command>ALTER PUBLICATION</command> - will be successful but later the walsender on the publisher or the - subscriber may throw an error. In this scenario, the user needs to - recreate the subscription after adjusting the column list or drop the - problematic publication using - <literal>ALTER SUBSCRIPTION ... DROP PUBLICATION</literal> and then add - it back after adjusting the column list. + with different column lists is not supported. See + <xref linkend="logical-replication-col-list-combining"/> for details of + potential problems when altering column lists. </para> <para> diff --git a/doc/src/sgml/ref/create_publication.sgml b/doc/src/sgml/ref/create_publication.sgml index b0d59ef47d2..f61641896a8 100644 --- a/doc/src/sgml/ref/create_publication.sgml +++ b/doc/src/sgml/ref/create_publication.sgml @@ -91,8 +91,10 @@ CREATE PUBLICATION <replaceable class="parameter">name</replaceable> When a column list is specified, only the named columns are replicated. If no column list is specified, all columns of the table are replicated through this publication, including any columns added later. It has no - effect on <literal>TRUNCATE</literal> commands. - </para> + effect on <literal>TRUNCATE</literal> commands. See + <xref linkend="logical-replication-col-lists"/> for details about column + lists. +</para> <para> Only persistent base tables and partitioned tables can be part of a |