Re: Dupe Key Violations in Logical Replication with PKs in Place

> On Nov 14, 2023, at 10:54 AM, Don Seiler  wrote:
> 
> Well this looks to be human error/cause after all. I made the mistake of announcing the upcoming migration and one eager developer connected to the new/subscription DB and ran some inserts (also running them on the old/publication DB). The inserts were all in one transaction, and look to be responsible for all 3 of duplicate key incidents.

So this would be about the 2 billionth or so episode in the DBA series titled "shit happens" ;-) Glad you figured it out.