From: Tom Lane <tgl@sss.pgh.pa.us>
To: oystein.arneson@cloudberries.no
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18795: Norwegian bokmål crashes again
Date: Wed, 05 Feb 2025 11:22:51 -0500
Message-ID: <816919.1738772571@sss.pgh.pa.us> (raw)
In-Reply-To: <816216.1738772073@sss.pgh.pa.us>
References: <18795-268389c4e50cbd4e@postgresql.org>
<816216.1738772073@sss.pgh.pa.us>
I wrote:
> PG Bug reporting form <noreply@postgresql.org> writes:
>> I downloaded the latest installer for windows and tried to install a local
>> database server with locale Norwegian Bokmål. Looks like this bug is back in
>> version 17? Or maybe it's windows 11 that is causing it?
> Sigh, did they rename it again?
Oh, never mind that. I'd forgotten about this recent change:
<para>
Disallow locale names containing non-ASCII characters (Thomas Munro)
</para>
<para>
This is only an issue on Windows, as such locale names are not used
elsewhere. They are problematic because it's quite unclear what
encoding such names are represented in (since the locale itself
defines the encoding to use). In
recent <productname>PostgreSQL</productname> releases, an abort in
the Windows runtime library could occur because of confusion about
that.
</para>
<para>
Anyone who encounters the new error message should either create a
new duplicated locale with an ASCII-only name using Windows Locale
Builder, or consider using BCP 47-compliant locale names
like <literal>tr-TR</literal>.
</para>
So your fix is to specify the locale explicitly to initdb,
along the lines of "--locale=no-NO" (I'm guessing about the
Norwegian locale to use, but it's probably close to that).
Was the error you got not sufficiently clear about this?
regards, tom lane
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-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, oystein.arneson@cloudberries.no, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18795: Norwegian bokmål crashes again
In-Reply-To: <816919.1738772571@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