Re: LC_COLLATE and pg_upgrade

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Bernhard Schrader <bernhard(dot)schrader(at)innogames(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: LC_COLLATE and pg_upgrade
Date: 2011-02-16 21:24:18
Message-ID: 201102162124.p1GLOIB29340@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Selva manickaraja 2011-02-17 01:29:44 Timeline Issue
Previous Message Joshua D. Drake 2011-02-16 21:12:39 Re: Postgres on NAS/NFS