Re: Logical Replication - "invalid ordering of speculative insertion changes"

2023-02-07 Thread Rahila Syed
Hi Joe, On Fri, Feb 3, 2023 at 1:42 AM Joe Wildish wrote: > Just a bump on this --- perhaps the error is a bug with the DBMS? > > From what I can see "speculative insertion changes" in this context means > INSERT..ON CONFLICT DML. Although I have some experience writing > extensions and

Re: Logical Replication - "invalid ordering of speculative insertion changes"

2023-02-02 Thread Joe Wildish
Just a bump on this --- perhaps the error is a bug with the DBMS? >From what I can see "speculative insertion changes" in this context means >INSERT..ON CONFLICT DML. Although I have some experience writing extensions >and simple patches for the code base, I don't know anything as a developer

Logical Replication - "invalid ordering of speculative insertion changes"

2023-01-31 Thread Joe Wildish
Hello, We have a logical replication publisher (13.7) and subscriber (14.6) where we are seeing the following error on the subscriber. IP address and publication name changed, otherwise verbatim: 2023-01-31 15:24:49 UTC:x.x.x.x(56276):super@pubdb:[1040971]: WARNING: tables were not