From: Peter Eisentraut <peter_e@gmx.net>
To: Bernhard Schrader <bernhard.schrader@innogames.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: LC_COLLATE and pg_upgrade
Date: Wed, 16 Feb 2011 13:54:45 +0200
Message-ID: <1297857285.8578.1.camel@fsopti579.F-Secure.com> (raw)
In-Reply-To: <1297689493.2293.5.camel@schrader-laptop>
References: <1297357018.2340.10.camel@schrader-laptop>
<1297689493.2293.5.camel@schrader-laptop>
On mån, 2011-02-14 at 14:18 +0100, Bernhard Schrader wrote:
> 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?
Why don't you just reinitialize your new database cluster with the same
locale spelling as the old one?
Your points are valid, but unfortunately difficult to handle in the
general case.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: peter_e@gmx.net, bernhard.schrader@innogames.de
Subject: Re: LC_COLLATE and pg_upgrade
In-Reply-To: <1297857285.8578.1.camel@fsopti579.F-Secure.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox