postgres.git / summary / log / commit / refs

commit    5b0c46ea0932e3be64081a277b5cc01fa9571689
Author:   Amit Kapila <akapila@postgresql.org>
Date:     Mon Nov 04 04:09:30 2024 +0000
First released in: 18.0

    Doc: Update the behavior of generated columns in Logical Replication.
    
    Commit 745217a051 misses updating the new behavior of generated columns in
    logical replication at a few places.
    
    Reported-by: Peter Smith, Ajin Cherian
    Author: Vignesh C
    Discussion: https://postgr.es/m/CALDaNm2JOO7szz9+uaQbjmgZOfzbM_9tAQdFF8H5BjkQeaJs0A@mail.gmail.com
    Discussion: https://postgr.es/m/B80D17B2-2C8E-4C7D-87F2-E5B4BE3C069E@gmail.com


 doc/src/sgml/ddl.sgml                 | 5 +++--
 doc/src/sgml/logical-replication.sgml | 4 +++-
 2 files changed, 6 insertions(+), 3 deletions(-)

diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml
index f6344b3b79a..f02f67d7b86 100644
--- a/doc/src/sgml/ddl.sgml
+++ b/doc/src/sgml/ddl.sgml
@@ -514,8 +514,9 @@ CREATE TABLE people (
     </listitem>
     <listitem>
      <para>
-      Generated columns are skipped for logical replication and cannot be
-      specified in a <command>CREATE PUBLICATION</command> column list.
+      Generated columns can be replicated during logical replication by
+      including them in the column list of the
+      <command>CREATE PUBLICATION</command> command.
      </para>
     </listitem>
    </itemizedlist>
diff --git a/doc/src/sgml/logical-replication.sgml b/doc/src/sgml/logical-replication.sgml
index 98a7ad0c272..b7e340824ca 100644
--- a/doc/src/sgml/logical-replication.sgml
+++ b/doc/src/sgml/logical-replication.sgml
@@ -1436,7 +1436,9 @@ test_sub=# SELECT * FROM child ORDER BY a;
    During initial data synchronization, only the published columns are
    copied.  However, if the subscriber is from a release prior to 15, then
    all the columns in the table are copied during initial data synchronization,
-   ignoring any column lists.
+   ignoring any column lists. If the subscriber is from a release prior to 18,
+   then initial table synchronization won't copy generated columns even if they
+   are defined in the publisher.
   </para>
 
    <warning id="logical-replication-col-list-combining">


[parent: 027124a872d7]