Date: Mon, 24 Sep 2012 08:55:00 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Rural Hunter <ruralhunter@gmail.com>,
	PostgreSQL-development <pgsql-hackers@postgresql.org>,
	Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed
Message-ID: <20120924125500.GA21242@momjian.us>
References: <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>
	<1348440393.18490.2.camel@vanquo.pezone.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <1348440393.18490.2.camel@vanquo.pezone.net>
User-Agent: Mutt/1.5.20 (2009-06-14)

On Sun, Sep 23, 2012 at 06:46:33PM -0400, Peter Eisentraut wrote:
> 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.

I can confirm that pg_upgrade does case-insensitive comparisons of
encoding/locale names:

	static void
	check_locale_and_encoding(ControlData *oldctrl,
	                          ControlData *newctrl)
	{
	    /* These are often defined with inconsistent case, so use pg_strcasecmp(). */
	    if (pg_strcasecmp(oldctrl->lc_collate, newctrl->lc_collate) != 0)
	        pg_log(PG_FATAL,
	               "old and new cluster lc_collate values do not match\n");
	    if (pg_strcasecmp(oldctrl->lc_ctype, newctrl->lc_ctype) != 0)
	        pg_log(PG_FATAL,
	               "old and new cluster lc_ctype values do not match\n");
	    if (pg_strcasecmp(oldctrl->encoding, newctrl->encoding) != 0)
	        pg_log(PG_FATAL,
	               "old and new cluster encoding values do not match\n");
	}

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

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