Re: String comparison fails for some cases after migration

Поиск
Список
Период
Сортировка
От Jayadevan M
Тема Re: String comparison fails for some cases after migration
Дата
Msg-id CAFS1N4jCt0ZMgEoF=68KJMwWYS6PgS9Ftdnug6zuypSF1LpktQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: String comparison fails for some cases after migration  (Julien Rouhaud <rjuju123@gmail.com>)
Список pgsql-general
Дерево обсуждения


On Wed, Oct 27, 2021 at 11:49 AM Julien Rouhaud <rjuju123@gmail.com> wrote:


Most likely you had a different version of the glibc or ICU libraries
on the new system, which lead to your indexes on collatable datatypes
partially corrupted.  See https://wiki.postgresql.org/wiki/Collations
for more details.

You can issue a REINDEX for each impacted index, or a database-wide REINDEX.

Tried creating  a new env with the same approach - just reindexing solved the problem. Thanks a lot.

Regards,
Jayadevan

В списке pgsql-general по дате отправления:

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: Determining if a table really changed in a trigger
Следующее
От: Marcos Pegoraro
Дата:
Сообщение: Re: Determining if a table really changed in a trigger