Re: Dupe Key Violations in Logical Replication with PKs in Place

Поиск
Список
Период
Сортировка
От Don Seiler
Тема Re: Dupe Key Violations in Logical Replication with PKs in Place
Дата
Msg-id CAHJZqBAatQLaHpZOBRX_yP5JboER0O9bs6OSORKegX1aoAgmgQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Dupe Key Violations in Logical Replication with PKs in Place  (Scott Ribe <scott_ribe@elevated-dev.com>)
Список pgsql-admin
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Don Seiler
Дата:
Сообщение: Re: Dupe Key Violations in Logical Replication with PKs in Place
Следующее
От: Scott Ribe
Дата:
Сообщение: Re: Dupe Key Violations in Logical Replication with PKs in Place