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(dot)klaver(at)aklaver(dot)com