Re: Inexplicable duplicate rows with unique constraint

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)