Re: String comparison fails for some cases after migration - Mailing list pgsql-general

From Tom Lane
Subject Re: String comparison fails for some cases after migration
Date
Msg-id 209375.1635315594@sss.pgh.pa.us
Whole thread Raw
In response to String comparison fails for some cases after migration  (Jayadevan M <maymala.jayadevan@gmail.com>)
List 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 by date:

Previous
From: Julien Rouhaud
Date:
Subject: Re: String comparison fails for some cases after migration
Next
From: Mitar
Date:
Subject: Re: Determining if a table really changed in a trigger