RE: row filtering for logical replication
От | tanghy.fnst@fujitsu.com |
---|---|
Тема | RE: row filtering for logical replication |
Дата | |
Msg-id | OS0PR01MB6113895D7964F03E9F57F9C7FB929@OS0PR01MB6113.jpnprd01.prod.outlook.com обсуждение исходный текст |
Ответ на | Re: row filtering for logical replication (Peter Smith <smithpb2250@gmail.com>) |
Ответы |
Re: row filtering for logical replication
|
Список | pgsql-hackers |
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. Regards Tang
В списке pgsql-hackers по дате отправления: