diff options
| author | Amit Kapila <akapila@postgresql.org> | 2024-11-04 09:39:30 +0530 |
|---|---|---|
| committer | Amit Kapila <akapila@postgresql.org> | 2024-11-04 09:39:30 +0530 |
| commit | 5b0c46ea0932e3be64081a277b5cc01fa9571689 (patch) | |
| tree | 08457415165a7ed1b862807ca2dcc5c5eac979a1 /doc/src | |
| parent | 027124a872d7b5dfddc69590af42f626b1727dba (diff) | |
| download | postgresql-5b0c46ea0932e3be64081a277b5cc01fa9571689.tar.gz postgresql-5b0c46ea0932e3be64081a277b5cc01fa9571689.zip | |
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
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ddl.sgml | 5 | ||||
| -rw-r--r-- | 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"> |