On Tue, Nov 9, 2021 at 2:03 PM tanghy.fnst@fujitsu.com
<tanghy.fnst@fujitsu.com> wrote:
>
> On Friday, November 5, 2021 1:14 PM, Peter Smith <smithpb2250@gmail.com> wrote:
> >
> > PSA new set of v37* patches.
> >
>
> Thanks for your patch. I have a problem when using this patch.
>
> The document about "create publication" in patch says:
>
> The <literal>WHERE</literal> clause should contain only columns that are
> part of the primary key or be covered by <literal>REPLICA
> IDENTITY</literal> otherwise, <command>DELETE</command> operations will not
> be replicated.
>
> But I tried this patch, the columns which could be contained in WHERE clause must be
> covered by REPLICA IDENTITY, but it doesn't matter if they are part of the primary key.
> (We can see it in Case 4 of publication.sql, too.) So maybe we should modify the document.
>
PG Docs is changed in v38-0004 [1]. Please check if it is OK.
------
[1] https://www.postgresql.org/message-id/CAHut%2BPvWCS%2BW_OLV60AZJucY1RFpkXS%3DhfvYWwpwyMvifdJxiQ%40mail.gmail.com
Kind Regards,
Peter Smith.
Fujitsu Australia