Re: String comparison fails for some cases after migration

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: String comparison fails for some cases after migration
Дата
Msg-id 209375.1635315594@sss.pgh.pa.us
обсуждение исходный текст
Ответ на String comparison fails for some cases after migration  (Jayadevan M <maymala.jayadevan@gmail.com>)
Список pgsql-general
Дерево обсуждения 
Jayadevan M <maymala.jayadevan@gmail.com> writes:
> We moved our PostgreSQL database from one hosting provider to another using
> pgbackrest.  In the new environment, some comparison operations  were
> failing.  The issue was fixed by running an update. But I am trying to find
> out what would have happened.

Did the underlying OS version change?  If so, see

https://wiki.postgresql.org/wiki/Locale_data_changes

            regards, tom lane

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

Предыдущее
От: Julien Rouhaud
Дата:
Сообщение: Re: String comparison fails for some cases after migration
Следующее
От: Mitar
Дата:
Сообщение: Re: Determining if a table really changed in a trigger