Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group