Re: How is this possible "publication does not exist"

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема Re: How is this possible "publication does not exist"
Дата
Msg-id CAA4eK1KJb9PFV6j=Gzm0jFmrfKnMPo571SpUoL0H521QEip6nA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How is this possible "publication does not exist"  (operations i <ioperations.c@gmail.com>)
Ответы Re: How is this possible "publication does not exist"  (operations i <ioperations.c@gmail.com>)
Список pgsql-bugs
Дерево обсуждения
On Wed, May 25, 2022 at 9:32 AM operations i <ioperations.c@gmail.com> wrote:
During a detailed test , I've found the order of replication slot creation and publication creation is not the key point , but after replication slot creation , there should not be any insertion to the table,so I wonder why the change ( my case insert) will lead to src/backend/catalog/pg_publication:1040 GetSysCacheOid1() cache miss.

It is due to the reason that both slot creation and 'insert' are before "CREATE PUBLICATION". Without inserts, it won't try to decode anything before the publication is created. Can you test it with the patch provided in the email [1] and if possible join that thread for discussion on this topic.


--
With Regards,
Amit Kapila.

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

Предыдущее
От: Andrey Borodin
Дата:
Сообщение: Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY
Следующее
От: Andres Freund
Дата:
Сообщение: Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY