Skip to content

Commit 9807617

Browse files
author
Amit Kapila
committed
Doc: Specify the interaction of publish_generated_columns with column list.
Author: Peter Smith <smithpb2250@gmail.com> Reviewed-by: David G. Johnston <david.g.johnston@gmail.com> Reviewed-by: Amit Kapila <amit.kapila16@gmail.com> Discussion: https://postgr.es/m/CAHut+PtnjLiNFFh-3f9cXH0wnwqjdkTjQNbVmZdZ1y+zKt_PPg@mail.gmail.com
1 parent f132815 commit 9807617

File tree

1 file changed

+6
-4
lines changed

1 file changed

+6
-4
lines changed

doc/src/sgml/ref/create_publication.sgml

Lines changed: 6 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -89,10 +89,12 @@ CREATE PUBLICATION <replaceable class="parameter">name</replaceable>
8989

9090
<para>
9191
When a column list is specified, only the named columns are replicated.
92-
The column list can contain stored generated columns as well. If no
93-
column list is specified, all table columns (except generated columns)
94-
are replicated through this publication, including any columns added
95-
later. It has no effect on <literal>TRUNCATE</literal> commands. See
92+
The column list can contain stored generated columns as well. If the
93+
column list is omitted, the publication will replicate all non-generated
94+
columns (including any added in the future) by default. Stored generated
95+
columns can also be replicated if <literal>publish_generated_columns</literal>
96+
is set to <literal>stored</literal>. Specifying a column list has no
97+
effect on <literal>TRUNCATE</literal> commands. See
9698
<xref linkend="logical-replication-col-lists"/> for details about column
9799
lists.
98100
</para>

0 commit comments

Comments
 (0)