Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8) - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8)
Date
Msg-id 1c22da3e-1b18-39b8-cecb-26777dc683f0@enterprisedb.com
Whole thread Raw
In response to Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8)  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8)
List pgsql-general
Tree view 
On 23.06.22 20:21, Adrian Klaver wrote:
>> Not sure why that is necessary? Is seems this is low hanging fruit 
>> that could dealt with by the equivalent of lower('en_US.UTF-8') = 
>> lower('en_US.utf-8').
> 
> Well that was clear as mud. My point was that I don't see why the end 
> user should have to do this when it could be handled internally in the 
> pg_restore code.

There are also cases where on one system the locale is spelled 
xx_YY.UTF8 and on another xx_YY.UTF-8.  If we start adjusting for case, 
should we adjust for this as well?  What other cases are there?

So this would need a bit more research.

pgsql-general by date:

Previous
From: Tomas Pospisek
Date:
Subject: Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8)
Next
From: "Mahendrakar, Prabhakar - Dell Team"
Date:
Subject: RE: Postgresql error : PANIC: could not locate a valid checkpoint record