From 9807617a9293f3fce867fbde99e0840cb5695a12 Mon Sep 17 00:00:00 2001 From: Amit Kapila Date: Tue, 29 Apr 2025 09:01:43 +0530 Subject: [PATCH] Doc: Specify the interaction of publish_generated_columns with column list. Author: Peter Smith Reviewed-by: David G. Johnston Reviewed-by: Amit Kapila Discussion: https://postgr.es/m/CAHut+PtnjLiNFFh-3f9cXH0wnwqjdkTjQNbVmZdZ1y+zKt_PPg@mail.gmail.com --- doc/src/sgml/ref/create_publication.sgml | 10 ++++++---- 1 file changed, 6 insertions(+), 4 deletions(-) diff --git a/doc/src/sgml/ref/create_publication.sgml b/doc/src/sgml/ref/create_publication.sgml index 73f0c8d89fb..802630f2df1 100644 --- a/doc/src/sgml/ref/create_publication.sgml +++ b/doc/src/sgml/ref/create_publication.sgml @@ -89,10 +89,12 @@ CREATE PUBLICATION name When a column list is specified, only the named columns are replicated. - The column list can contain stored generated columns as well. If no - column list is specified, all table columns (except generated columns) - are replicated through this publication, including any columns added - later. It has no effect on TRUNCATE commands. See + The column list can contain stored generated columns as well. If the + column list is omitted, the publication will replicate all non-generated + columns (including any added in the future) by default. Stored generated + columns can also be replicated if publish_generated_columns + is set to stored. Specifying a column list has no + effect on TRUNCATE commands. See for details about column lists. -- 2.30.2