Re: How is this possible "publication does not exist"
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.
On Tue, May 24, 2022 at 9:38 AM Amit Kapila <amit.kapila16@gmail.com> wrote:
On Tue, May 24, 2022 at 11:42 AM operations i <ioperations.c@gmail.com> wrote:
>
> Thanks for your quick response,So the problem is user's misusing it. Is there any plan to throw an error when using logical replication like this?
>
It could be tricky to detect that but if you have ideas on how to do
that, I am all ears. I think you can wait for that other thread [1] to
reach conclusion and see if that might help your case as well.
Note - Please keep 'pgsql*' lists in cc while replying as others can
also help/provide suggestions.
[1] - https://www.postgresql.org/message-id/CAHut%2BPvMbCsL8PAz1Qc6LNoL0Ag0y3YJtPVJ8V0xVXJOPb%2B0xw%40mail.gmail.com
--
With Regards,
Amit Kapila.
Вложения
В списке pgsql-bugs по дате отправления:
Предыдущее
От: Alvaro HerreraДата:
Сообщение: Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY
Следующее
От: Robert HaasДата:
Сообщение: Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY