Re: row filtering for logical replication

Поиск
Список
Период
Сортировка
От Ajin Cherian
Тема Re: row filtering for logical replication
Дата
Msg-id CAFPTHDYghMxNqfS4gtMY7Tkyyibgv2gjQvpynzwLOKCju0c_LA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: row filtering for logical replication  (vignesh C <vignesh21@gmail.com>)
Список pgsql-hackers
On Wed, Dec 1, 2021 at 3:27 AM vignesh C <vignesh21@gmail.com> wrote:
>
> Here we will not be able to do a direct comparison as we store the
> transformed where clause in the pg_publication_rel table. We will have
> to transform the where clause and then check. I have attached a patch
> where we can check the transformed where clause and see if the where
> clause is the same or not. If you are ok with this approach you could
> make similar changes.

thanks for your patch, I have used the same logic with minor changes
and shared it with Peter for v44.

regards,
Ajin Cherian
Fujitsu Australia



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

Предыдущее
От: Greg Nancarrow
Дата:
Сообщение: Re: Data is copied twice when specifying both child and parent table in publication
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Optionally automatically disable logical replication subscriptions on error