diff --git a/doc/src/sgml/logical-replication.sgml b/doc/src/sgml/logical-replication.sgml index e4f5d84..e39771d 100644 --- a/doc/src/sgml/logical-replication.sgml +++ b/doc/src/sgml/logical-replication.sgml @@ -1664,24 +1664,24 @@ test_sub=# SELECT * from tab_gen_to_gen; Generated columns are not published by default, but users can opt to - publish generated columns just like regular ones. + publish stored generated columns just like regular ones. There are two ways to do this: - Enable the PUBLICATION parameter + Set the PUBLICATION parameter - publish_generated_columns. This instructs - PostgreSQL logical replication to publish current and future generated - columns of the publication's tables. + publish_generated_columns to stored. + This instructs PostgreSQL logical replication to publish current and + future stored generated columns of the publication's tables. Specify a table column list - to explicity nominate which generated columns will be published. + to explicitly nominate which stored generated columns will be published. @@ -1701,7 +1701,7 @@ test_sub=# SELECT * from tab_gen_to_gen; The following table summarizes behavior when there are generated columns involved in the logical replication. Results are shown for when - publishing generated columns is disabled (default), and for when it is + publishing generated columns is not enabled, and for when it is enabled. @@ -1791,12 +1791,12 @@ CREATE TABLE Create the PUBLICATION and the SUBSCRIPTION. Note that the publication specifies a column list for table t2. - The publication also sets parameter publish_generated_columns=false, - but that is just for demonstration because false is the + The publication also sets parameter publish_generated_columns=none, + but that is just for demonstration because none is the default anyway. test_pub=# CREATE PUBLICATION pub1 FOR TABLE t1, t2(a,c) -test_pub-# WITH (publish_generated_columns=false); +test_pub-# WITH (publish_generated_columns=none); CREATE PUBLICATION @@ -1846,12 +1846,12 @@ test_sub=# SELECT * FROM t1; t1.c is a generated column. It is not replicated because - publish_generated_columns=false. The subscriber + publish_generated_columns=none. The subscriber t2.c default column value is used. t1.d is a generated column. It is not replicated because - publish_generated_columns=false. The subscriber + publish_generated_columns=none. The subscriber t2.d generated column value is used.