Postgres Pro
Downloads
Home   >   mailing lists

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

From Don Seiler
Subject Re: Dupe Key Violations in Logical Replication with PKs in Place
Date
Msg-id CAHJZqBAatQLaHpZOBRX_yP5JboER0O9bs6OSORKegX1aoAgmgQ@mail.gmail.com
Whole thread Raw
In response to Re: Dupe Key Violations in Logical Replication with PKs in Place  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-admin
Tree view
On Tue, Nov 14, 2023 at 10:12 AM Scott Ribe <scott_ribe@elevated-dev.com> wrote:
> On Nov 14, 2023, at 9:10 AM, Don Seiler <don@seiler.us> wrote:
>
> The data is UUID strings (typical alphanumeric characters and hyphens) stored in varchar(36) fields,

Well, there you go: digits and dashes, the sort order changed.

But this is a logical replica. That problem and its re-indexing solution should only apply to physical replicas.

--
Don Seiler
www.seiler.us

pgsql-admin by date:

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