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 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.