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

From Adrian Klaver
Subject Re: Logical replication from 11.x to 12.x and "unique key violations"
Date
Msg-id 4b444d07-241c-b327-df64-da2ea15ed93b@aklaver.com
Whole thread Raw
In response to Re: Logical replication from 11.x to 12.x and "unique key violations"  (Thomas Kellerer <shammat@gmx.net>)
Responses Re: Logical replication from 11.x to 12.x and "unique key violations"
List pgsql-general
On 7/20/20 10:42 PM, Thomas Kellerer wrote:
> Adrian Klaver schrieb am 20.07.2020 um 16:45:
>> On 7/20/20 7:22 AM, Thomas Kellerer wrote:
>>>> I have a strange error when using logical replication between a 11.2


> 
>> Where is "xxx_pkey" coming from, e.g. sequence?
> 
> No, as mentioned, those are varchar(20) columns.
> The values are generated by the application (no default value defined for the column)

Aah I see my mistake I was going off your follow up question not the 
original post. In that original post though you had the PK containing a 
varchar(100) column. Can we see the table schema and the PK definition 
for at least one of the tables that threw an error?




-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Thorsten Schöning
Date:
Subject: Re: How to restore a dump containing CASTs into a database with a new user?
Next
From: Mohamed Wael Khobalatte
Date:
Subject: Switching Primary Keys to BigInt