Re: Dupe Key Violations in Logical Replication with PKs in Place - Mailing list pgsql-admin

From Scott Ribe
Subject Re: Dupe Key Violations in Logical Replication with PKs in Place
Date
Msg-id 5181C120-C6B2-4186-BB67-2B22660D5A7B@elevated-dev.com
Whole thread Raw
In response to Re: Dupe Key Violations in Logical Replication with PKs in Place  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: Dupe Key Violations in Logical Replication with PKs in Place
List pgsql-admin
> On Nov 14, 2023, at 9:04 AM, Ron <ronljohnsonjr@gmail.com> wrote:
>
> What data type(s) in those columns, and what locale on each server? Maybe the change from 18.04/12 to 22.04/15 has
causedsome weirdness with "foreign" characters. 

Problems with the locale updates are not limited to non-ASCII characters, sorting rules involving "-" changed, for
instance.When you make that OS upgrade, you really, really, need to reindex all text types. 


pgsql-admin by date:

Previous
From: Ron
Date:
Subject: Re: Dupe Key Violations in Logical Replication with PKs in Place
Next
From: Don Seiler
Date:
Subject: Re: Dupe Key Violations in Logical Replication with PKs in Place