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

Поиск
Список
Период
Сортировка
От Scott Ribe
Тема Re: Dupe Key Violations in Logical Replication with PKs in Place
Дата
Msg-id 5181C120-C6B2-4186-BB67-2B22660D5A7B@elevated-dev.com
обсуждение исходный текст
Ответ на Re: Dupe Key Violations in Logical Replication with PKs in Place  (Ron <ronljohnsonjr@gmail.com>)
Ответы Re: Dupe Key Violations in Logical Replication with PKs in Place  (Don Seiler <don@seiler.us>)
Список 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 по дате отправления:

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