pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruce Momjian <bruce@momjian.us>
Cc: Skjalg A. Skagen <skjalg.skagen@pm.me>
Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: Re: PostgreSQL 12 installation fails because locale name contained non-english characters
Date: Tue, 05 Nov 2019 12:22:21 -0500
Message-ID: <11659.1572974541@sss.pgh.pa.us> (raw)
In-Reply-To: <20191105024819.GB12780@momjian.us>
References: <_Rkh_eJ7FKRUdGms9GAub53-5uvodq4uvTIrbgsTQ13wwHJwj7ofpHXUUtT0JMQft6oXI68hqJTx1bLIaejbuTyu29xeTGrSBCCgl40U1GA=@pm.me>
	<20191105024819.GB12780@momjian.us>

Bruce Momjian <bruce@momjian.us> writes:
> On Thu, Oct 24, 2019 at 11:06:01AM +0000, Skjalg A. Skagen wrote:
>> I tried to install PostgreSQL 12 with the "Norwegian Bokmål, Norway" locale in
>> hope that it would, among other things, provide proper support for Norwegian
>> characters out-of-the-box.
>> But initcluster.vbs appear to fail during post-install because the locale name
>> contains a Norwegian character that is being mishandled (full log in attached
>> zip file):
>> initdb: error: invalid locale name "NorwegianBokm†l,Norway"

> This has been fixed with the this patch:
> 	https://www.postgresql.org/message-id/E1iMcHC-0007Ci-7G@gemulon.postgresql.org

Hm, I'm not entirely sure that it has been.  The original code supposed
that the locale name is spelled "Norwegian (Bokmål)_Norway", and the
recent patch you mention extended that to allow "Norwegian Bokmål_Norway".
But this report, if accurate, shows yet another variant.  Skjalg,
would you confirm that there's a comma and space before "Norway" in
the locale name as you see it?  (Your log clearly shows it with a
space in the registry entries, but it looks like initdb might be
seeing it as not having any spaces, which is why I'm confused.)

I wonder whether we need to relax the matching code to be entirely
agnostic about spaces and punctuation in the Windows locale name.

			regards, tom lane





view thread (6+ messages)  latest in thread

Message-ID: <11659.1572974541@sss.pgh.pa.us>
Permalink:  ../11659.1572974541@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/11659.1572974541@sss.pgh.pa.us

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-bugs@postgresql.org
  Cc: tgl@sss.pgh.pa.us, bruce@momjian.us, skjalg.skagen@pm.me
  Subject: Re: PostgreSQL 12 installation fails because locale name contained non-english characters
  In-Reply-To: <11659.1572974541@sss.pgh.pa.us>
  References: <_Rkh_eJ7FKRUdGms9GAub53-5uvodq4uvTIrbgsTQ13wwHJwj7ofpHXUUtT0JMQft6oXI68hqJTx1bLIaejbuTyu29xeTGrSBCCgl40U1GA=@pm.me> <20191105024819.GB12780@momjian.us> <11659.1572974541@sss.pgh.pa.us>

* 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