diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ddl.sgml | 8 | ||||
| -rw-r--r-- | doc/src/sgml/protocol.sgml | 2 | ||||
| -rw-r--r-- | doc/src/sgml/ref/create_publication.sgml | 20 |
3 files changed, 26 insertions, 4 deletions
diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml index f02f67d7b86..898b6ddc8df 100644 --- a/doc/src/sgml/ddl.sgml +++ b/doc/src/sgml/ddl.sgml @@ -514,9 +514,11 @@ CREATE TABLE people ( </listitem> <listitem> <para> - Generated columns can be replicated during logical replication by - including them in the column list of the - <command>CREATE PUBLICATION</command> command. + Generated columns are allowed to be replicated during logical replication + according to the <command>CREATE PUBLICATION</command> parameter + <link linkend="sql-createpublication-params-with-publish-generated-columns"> + <literal>publish_generated_columns</literal></link> or by including them + in the column list of the <command>CREATE PUBLICATION</command> command. </para> </listitem> </itemizedlist> diff --git a/doc/src/sgml/protocol.sgml b/doc/src/sgml/protocol.sgml index 71b6b2a535f..4c0a1a00688 100644 --- a/doc/src/sgml/protocol.sgml +++ b/doc/src/sgml/protocol.sgml @@ -7477,7 +7477,7 @@ psql "dbname=postgres replication=database" -c "IDENTIFY_SYSTEM;" </variablelist> <para> - Next, one of the following submessages appears for each column: + Next, one of the following submessages appears for each published column: <variablelist> <varlistentry> diff --git a/doc/src/sgml/ref/create_publication.sgml b/doc/src/sgml/ref/create_publication.sgml index d2cac06fd76..f8e217d6610 100644 --- a/doc/src/sgml/ref/create_publication.sgml +++ b/doc/src/sgml/ref/create_publication.sgml @@ -189,6 +189,26 @@ CREATE PUBLICATION <replaceable class="parameter">name</replaceable> </listitem> </varlistentry> + <varlistentry id="sql-createpublication-params-with-publish-generated-columns"> + <term><literal>publish_generated_columns</literal> (<type>boolean</type>)</term> + <listitem> + <para> + Specifies whether the generated columns present in the tables + associated with the publication should be replicated. + The default is <literal>false</literal>. + </para> + + <note> + <para> + If the subscriber is from a release prior to 18, then initial table + synchronization won't copy generated columns even if parameter + <literal>publish_generated_columns</literal> is true in the + publisher. + </para> + </note> + </listitem> + </varlistentry> + <varlistentry id="sql-createpublication-params-with-publish-via-partition-root"> <term><literal>publish_via_partition_root</literal> (<type>boolean</type>)</term> <listitem> |