File tree Expand file tree Collapse file tree 2 files changed +6
-3
lines changed Expand file tree Collapse file tree 2 files changed +6
-3
lines changed Original file line number Diff line number Diff line change @@ -514,8 +514,9 @@ CREATE TABLE people (
514
514
</listitem>
515
515
<listitem>
516
516
<para>
517
- Generated columns are skipped for logical replication and cannot be
518
- specified in a <command>CREATE PUBLICATION</command> column list.
517
+ Generated columns can be replicated during logical replication by
518
+ including them in the column list of the
519
+ <command>CREATE PUBLICATION</command> command.
519
520
</para>
520
521
</listitem>
521
522
</itemizedlist>
Original file line number Diff line number Diff line change @@ -1436,7 +1436,9 @@ test_sub=# SELECT * FROM child ORDER BY a;
1436
1436
During initial data synchronization, only the published columns are
1437
1437
copied. However, if the subscriber is from a release prior to 15, then
1438
1438
all the columns in the table are copied during initial data synchronization,
1439
- ignoring any column lists.
1439
+ ignoring any column lists. If the subscriber is from a release prior to 18,
1440
+ then initial table synchronization won't copy generated columns even if they
1441
+ are defined in the publisher.
1440
1442
</para>
1441
1443
1442
1444
<warning id="logical-replication-col-list-combining">
You can’t perform that action at this time.
0 commit comments