Commit376af68

Amit Kapila

committed

Doc: fix column list vs. replica identity rules.

It was not strictly correct to say that a column list must always includereplica identity columns because that is true for only updates anddeletes.Author: Peter SmithReviwed-by: Vignesh C, Amit KapilaBackpatch-through: 15, where it was introducedDiscussion:https://postgr.es/m/CAHut+PvOuc9=_4TbASc5=VUqh16UWtFO3GzcKQK_5m1hrW3vqg@mail.gmail.com

1 parentbfb9dfd commit376af68Copy full SHA for 376af68

File tree

-2

lines changed

-2

lines changed

Lines changed: 9 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -90,8 +90,8 @@ CREATE PUBLICATION <replaceable class="parameter">name</replaceable>`
`90`	`90`	`<para>`
`91`	`91`	`When a column list is specified, only the named columns are replicated.`
`92`	`92`	`If no column list is specified, all columns of the table are replicated`
`93`		`- through this publication, including any columns added later. If a column`
`94`		`-list is specified, it must include the replica identity columns.`
	`93`	`+ through this publication, including any columns added later.It has no`
	`94`	`+effect on <literal>TRUNCATE</literal> commands.`
`95`	`95`	`</para>`
`96`	`96`
`97`	`97`	`<para>`
`@@ -252,6 +252,13 @@ CREATE PUBLICATION <replaceable class="parameter">name</replaceable>`
`252`	`252`	`disallowed on those tables.`
`253`	`253`	`</para>`
`254`	`254`
	`255`	`+ <para>`
	`256`	`+ Any column list must include the <literal>REPLICA IDENTITY</literal> columns`
	`257`	`+ in order for <command>UPDATE</command> or <command>DELETE</command>`
	`258`	`+ operations to be published. There are no column list restrictions if the`
	`259`	`+ publication publishes only <command>INSERT</command> operations.`
	`260`	`+ </para>`
	`261`	`+`
`255`	`262`	`<para>`
`256`	`263`	`A row filter expression (i.e., the <literal>WHERE</literal> clause) must contain only`
`257`	`264`	`columns that are covered by the <literal>REPLICA IDENTITY</literal>, in`

Comments

(0)