Re: adding partitioned tables to publications

Поиск
Список
Период
Сортировка
От Rafia Sabih
Тема Re: adding partitioned tables to publications
Дата
Msg-id CA+FpmFeusJ3oDYmoQFk4CW1Z1ZG7RrZ36bFy-hm9Jc4gie-gpw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: adding partitioned tables to publications  (Amit Langote <amitlangote09@gmail.com>)
Ответы Re: adding partitioned tables to publications
Список pgsql-hackers

Hi Amit,

On Fri, 11 Oct 2019 at 08:06, Amit Langote <amitlangote09@gmail.com> wrote:

Thanks for sharing this case.  I hadn't considered it, but you're
right that it should be handled sensibly.  I have fixed table sync
code to handle this case properly.  Could you please check your case
with the attached updated patch?

I was checking this today and found that the behavior doesn't change much with the updated patch. The tables are still replicated, just that a select count from parent table shows 0, rest of the partitions including default one has the data from the publisher. I was expecting more like an error at subscriber saying the table type is not same. 

Please find the attached file for the test case, in case something is unclear.

--
Regards,
Rafia Sabih
Вложения

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

Предыдущее
От: Euler Taveira
Дата:
Сообщение: Re: auxiliary processes in pg_stat_ssl
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Missed check for too-many-children in bgworker spawning