Re: row filtering for logical replication

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