Re: Logical replication from 11.x to 12.x and "unique key violations" - Mailing list pgsql-general

From Tom Lane
Subject Re: Logical replication from 11.x to 12.x and "unique key violations"
Date
Msg-id 578923.1595268285@sss.pgh.pa.us
Whole thread Raw
In response to Re: Logical replication from 11.x to 12.x and "unique key violations"  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Logical replication from 11.x to 12.x and "unique key violations"
List pgsql-general
Adrian Klaver <adrian.klaver@aklaver.com> writes:
> I'm probably missing something, but would that not result in a 'key not 
> found' type of error. The OP is seeing "duplicate key value violates 
> unique constraint xxx_pkey". To me that indicates a doubling up of at 
> least some of the data replication.

[ squint... ]  Sorry, I completely misread the error condition.

Yeah, duplicate keys does seem odd here.  Can you provide a self
contained example?

            regards, tom lane



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Logical replication from 11.x to 12.x and "unique key violations"
Next
From: John Ashmead
Date:
Subject: Re: Logical replication from 11.x to 12.x and "unique key violations"