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.
[image: image.png]
On Tue, May 24, 2022 at 9:38 AM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
> On Tue, May 24, 2022 at 11:42 AM operations i <ioperations(dot)c(at)gmail(dot)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.
>