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)