Re: Logical replication from 11.x to 12.x and "unique key violations"

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