Re: LC_COLLATE and pg_upgrade - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: LC_COLLATE and pg_upgrade
Date
Msg-id 201102162124.p1GLOIB29340@momjian.us
Whole thread Raw
In response to Re: LC_COLLATE and pg_upgrade  (Bernhard Schrader <bernhard.schrader@innogames.de>)
List pgsql-admin
Bernhard Schrader wrote:
> Doesn't anyone know if I could override this settings?
> LC_COLLATE should be interesting for sort order, and while both is utf8,
> it should work or am I totally wrong?
>
> As far as I read right now, LC_COLLATE is a read_only variable which is
> used while initdb. But why does the pg_upgrade script doesn't see that
> utf8 and UTF-8 are the same? Is it just a string compare?

Yes, just a string compare.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

pgsql-admin by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Postgres on NAS/NFS
Next
From: Selva manickaraja
Date:
Subject: Timeline Issue