Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 5DDAC1337BBC for ; Wed, 16 Feb 2011 17:24:31 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 23427-04 for ; Wed, 16 Feb 2011 21:24:24 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from momjian.us (momjian.us [70.90.9.53]) by mail.postgresql.org (Postfix) with ESMTP id 90C571337BD6 for ; Wed, 16 Feb 2011 17:24:23 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id p1GLOIB29340; Wed, 16 Feb 2011 16:24:18 -0500 (EST) From: Bruce Momjian Message-Id: <201102162124.p1GLOIB29340@momjian.us> Subject: Re: LC_COLLATE and pg_upgrade In-Reply-To: <1297689493.2293.5.camel@schrader-laptop> To: Bernhard Schrader Date: Wed, 16 Feb 2011 16:24:18 -0500 (EST) CC: pgsql-admin@postgresql.org X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201102/156 X-Sequence-Number: 36795 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 http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +