Search Postgresql Archives

Re: 9.0 to 9.2 pg_upgrade pain due to collation mismatch

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Peter Eisentraut <peter_e@xxxxxxx> writes:
> On 9/12/12 2:31 PM, Tom Lane wrote:
>> "C" is the official name of that locale.  Not sure how you got it to say
>> "POSIX" ... maybe we didn't have normalization of the locale name back
>> then?

> Says who?

Says setlocale(), at least on the Fedora machine I just checked.
The reason I see this:

$ initdb --locale=POSIX
The files belonging to this database system will be owned by user "tgl".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

is that setlocale is returning "C" as the canonical name of the locale.

			regards, tom lane


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux