diff options
| author | Amit Kapila <akapila@postgresql.org> | 2022-09-02 16:44:52 +0530 |
|---|---|---|
| committer | Amit Kapila <akapila@postgresql.org> | 2022-09-02 16:44:52 +0530 |
| commit | 376af686111e57929c626254eb403c0e810d8e22 (patch) | |
| tree | 135e90a955dd7a918b46daaea954624c22557ba8 | |
| parent | bfb9dfd93720098cf8f3e7d802df9b02ebe3dc20 (diff) | |
| download | postgresql-376af686111e57929c626254eb403c0e810d8e22.tar.gz postgresql-376af686111e57929c626254eb403c0e810d8e22.zip | |
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
| -rw-r--r-- | doc/src/sgml/ref/create_publication.sgml | 11 |
1 files changed, 9 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/create_publication.sgml b/doc/src/sgml/ref/create_publication.sgml index 5790d762705..b0d59ef47d2 100644 --- a/doc/src/sgml/ref/create_publication.sgml +++ b/doc/src/sgml/ref/create_publication.sgml @@ -90,8 +90,8 @@ CREATE PUBLICATION <replaceable class="parameter">name</replaceable> <para> 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 <literal>TRUNCATE</literal> commands. </para> <para> @@ -253,6 +253,13 @@ CREATE PUBLICATION <replaceable class="parameter">name</replaceable> </para> <para> + Any column list must include the <literal>REPLICA IDENTITY</literal> columns + in order for <command>UPDATE</command> or <command>DELETE</command> + operations to be published. There are no column list restrictions if the + publication publishes only <command>INSERT</command> operations. + </para> + + <para> A row filter expression (i.e., the <literal>WHERE</literal> clause) must contain only columns that are covered by the <literal>REPLICA IDENTITY</literal>, in order for <command>UPDATE</command> and <command>DELETE</command> operations |