RE: row filtering for logical replication

Поиск
Список
Период
Сортировка
От tanghy.fnst@fujitsu.com
Тема RE: row filtering for logical replication
Дата
Msg-id OS0PR01MB6113F72C48995B153A8FCD21FB989@OS0PR01MB6113.jpnprd01.prod.outlook.com
обсуждение исходный текст
Ответ на Re: row filtering for logical replication  (Peter Smith <smithpb2250@gmail.com>)
Список pgsql-hackers
On Wednesday, November 10, 2021 7:46 AM Peter Smith <smithpb2250@gmail.com> wrote:
> 
> 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.
> 

Thanks, this change looks good to me.

Regards
Tang

В списке pgsql-hackers по дате отправления:

Предыдущее
От: gg pw
Дата:
Сообщение: Re: Reuse of State value in Aggregates
Следующее
От: Dilip Kumar
Дата:
Сообщение: Re: Printing backtrace of postgres processes