From 376af686111e57929c626254eb403c0e810d8e22 Mon Sep 17 00:00:00 2001 From: Amit Kapila Date: Fri, 2 Sep 2022 16:44:52 +0530 Subject: [PATCH] Doc: fix column list vs. replica identity rules. It was not strictly correct to say that a column list must always include replica identity columns because that is true for only updates and deletes. Author: Peter Smith Reviwed-by: Vignesh C, Amit Kapila Backpatch-through: 15, where it was introduced Discussion: https://postgr.es/m/CAHut+PvOuc9=_4TbASc5=VUqh16UWtFO3GzcKQK_5m1hrW3vqg@mail.gmail.com --- doc/src/sgml/ref/create_publication.sgml | 11 +++++++++-- 1 file changed, 9 insertions(+), 2 deletions(-) diff --git a/doc/src/sgml/ref/create_publication.sgml b/doc/src/sgml/ref/create_publication.sgml index 5790d76270..b0d59ef47d 100644 --- a/doc/src/sgml/ref/create_publication.sgml +++ b/doc/src/sgml/ref/create_publication.sgml @@ -90,8 +90,8 @@ CREATE PUBLICATION name When a column list is specified, only the named columns are replicated. If no column list is specified, all columns of the table are replicated - through this publication, including any columns added later. If a column - list is specified, it must include the replica identity columns. + through this publication, including any columns added later. It has no + effect on TRUNCATE commands. @@ -252,6 +252,13 @@ CREATE PUBLICATION name disallowed on those tables. + + Any column list must include the REPLICA IDENTITY columns + in order for UPDATE or DELETE + operations to be published. There are no column list restrictions if the + publication publishes only INSERT operations. + + A row filter expression (i.e., the WHERE clause) must contain only columns that are covered by the REPLICA IDENTITY, in -- 2.30.2