Commit5b0c46e

Amit Kapila

committed

Doc: Update the behavior of generated columns in Logical Replication.

Commit745217a misses updating the new behavior of generated columns inlogical replication at a few places.Reported-by: Peter Smith, Ajin CherianAuthor: Vignesh CDiscussion:https://postgr.es/m/CALDaNm2JOO7szz9+uaQbjmgZOfzbM_9tAQdFF8H5BjkQeaJs0A@mail.gmail.comDiscussion:https://postgr.es/m/B80D17B2-2C8E-4C7D-87F2-E5B4BE3C069E@gmail.com

1 parent027124a commit5b0c46eCopy full SHA for 5b0c46e

File tree

-3

lines changed

-3

lines changed

Lines changed: 3 additions & 2 deletions

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>`

Lines changed: 3 additions & 1 deletion

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">`

Comments

(0)