On 16/01/2020 17:27, Adrian Klaver wrote:
On 1/16/20 9:24 AM, Richard van der Hoff wrote:
It seems like a plausible explanation but it's worth noting that all
the indexed data here is (despite being in text columns), plain ascii.
I'm surprised that a change in collation rules would change the
sorting of such strings, and hence that it could lead to this problem.
Am I naive?
In psql who does:
\l the_database_name
show?
synapse=> \l synapse
List of databases
Name | Owner | Encoding | Collate | Ctype | Access
privileges
---------+----------+----------+-------------+-------------+-----------------------
synapse | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
postgres=CTc/postgres+
| | | | |
=Tc/postgres +
| | | | |
synapse=CTc/postgres
(1 row)
