Re: Added schema level support for publication.

Поиск
Список
Период
Сортировка
От vignesh C
Тема Re: Added schema level support for publication.
Дата
Msg-id CALDaNm3tQuF4SDMkuSv0xJDRQAhQ5Ow_UT9if3BTE3ocnKQfDA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Added schema level support for publication.  (Greg Nancarrow <gregn4422@gmail.com>)
Ответы Re: Added schema level support for publication.
Список pgsql-hackers
On Fri, Jul 9, 2021 at 12:12 PM Greg Nancarrow <gregn4422@gmail.com> wrote:
>
> On Fri, Jul 9, 2021 at 1:28 PM houzj.fnst@fujitsu.com
> <houzj.fnst@fujitsu.com> wrote:
> >
> > Currently, postgres caches publication actions info in the
> > RelationData::rd_pubactions, but after applying the patch, it seems
> > rd_pubactions is not initialized when using schema level publication.
> >
> > It cound result in some unexpected behaviour when checking if command can be
> > executed with current replica identity.
> >
>
> While testing this patch, I'm finding that for a FOR SCHEMA
> publication, UPDATEs and DELETEs on tables belonging to that schema
> are not getting replicated (but INSERTs and TRUNCATEs are).
> Could this be related to the issues that Hou-san has identified?

Thanks for reporting this issue. I felt this issue is the same as the issue which Hou San had reported. This issue is fixed in the v10 patch attached at [1].
[1] - https://www.postgresql.org/message-id/CALDaNm2%2BtR%2B8R-sD1CSyMbZcZbkintZE-avefjsp7LCkm6HMmw%40mail.gmail.com

Regards,
Vignesh

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

Предыдущее
От: vignesh C
Дата:
Сообщение: Re: Added schema level support for publication.
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: row filtering for logical replication