Received: from magus.postgresql.org ([87.238.57.229])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <peter_e@gmx.net>) id 1TFuwh-0000yh-Cq
	for pgsql-hackers@postgresql.org; Sun, 23 Sep 2012 22:46:39 +0000
Received: from mailout-de.gmx.net ([213.165.64.22])
	by magus.postgresql.org with smtp (Exim 4.72)
	(envelope-from <peter_e@gmx.net>) id 1TFuwf-0003Fw-FB
	for pgsql-hackers@postgresql.org; Sun, 23 Sep 2012 22:46:38 +0000
Received: (qmail invoked by alias); 23 Sep 2012 22:46:36 -0000
Received: from pool-108-52-108-60.phlapa.fios.verizon.net (EHLO [192.168.1.4])
	[108.52.108.60]
	by mail.gmx.net (mp028) with SMTP; 24 Sep 2012 00:46:36 +0200
X-Authenticated: #495269
X-Provags-ID: V01U2FsdGVkX19lO+o7m7Jlm1EXGXd490fqEmWEaqO9+6BOoN7cVl
	bzik65F9NcUm/O
Message-ID: <1348440393.18490.2.camel@vanquo.pezone.net>
Subject: Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed
From: Peter Eisentraut <peter_e@gmx.net>
To: Rural Hunter <ruralhunter@gmail.com>
Cc: Bruce Momjian <bruce@momjian.us>, PostgreSQL-development
	<pgsql-hackers@postgresql.org>, Tom Lane <tgl@sss.pgh.pa.us>
Date: Sun, 23 Sep 2012 18:46:33 -0400
In-Reply-To: <505F1A98.9090901@gmail.com>
References: <50535302.8080000@gmail.com> <20120914183915.GA5933@momjian.us>
	<5053F896.60005@gmail.com> <20120915180603.GA20907@momjian.us>
	<505557CD.8090304@gmail.com> <20120916171746.GA24907@momjian.us>
	<28666.1347833056@sss.pgh.pa.us> <20120917043236.GA20123@momjian.us>
	<5056AF29.3040903@gmail.com> <20120917210723.GA30394@momjian.us>
	<20120918232239.GA2014@momjian.us> <505C307E.20501@gmail.com>
	<1348403628.18490.1.camel@vanquo.pezone.net>
	<505F1A98.9090901@gmail.com>
Content-Type: text/plain; charset="UTF-8"
X-Mailer: Evolution 3.4.3-1 
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit
X-Y-GMX-Trusted: 0
X-Pg-Spam-Score: -2.7 (--)
X-Archive-Number: 201209/849
X-Sequence-Number: 213877

On Sun, 2012-09-23 at 22:20 +0800, Rural Hunter wrote:
> Ah yes, seems I used a wrong parameter. The --locale='zh_CN.utf8' 
> works. --locale='zh_CN.UTF8' also works. But still the question is, 
> should the encoding name be case sensitive?

PostgreSQL treats encoding names as case insensitive.

But it depends on the operating system whether locale names are case
sensitive.