Re: PostgreSQL Windows Installer defaults to "English_United States.1252" when choosing locale starting with "English"

From: Sandeep Thakkar <sandeep(dot)thakkar(at)enterprisedb(dot)com>
To: Ben Caspi <benc(at)aidoc(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org, Liran Amrani <lirana(at)aidoc(dot)com>, Avi Uziel <avi(dot)uziel(at)aidoc(dot)com>, Shahar Amram <shahara(at)aidoc(dot)com>
Subject: Re: PostgreSQL Windows Installer defaults to "English_United States.1252" when choosing locale starting with "English"
Date: 2025-07-09 12:40:49
Message-ID: CANFyU94_OPq+A5H7Ysmy=7BGWAYndt8WUa1a0fnQdmRJ6TzGvQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Yes, you are correct. I got the same result. But it was correct when I
chose the BCP-47 name like en-uk. Probably something to do with how initdb
is handling the long names.

On Mon, Jul 7, 2025 at 5:50 PM Sandeep Thakkar <
sandeep(dot)thakkar(at)enterprisedb(dot)com> wrote:

> Hi,
>
> I'll have a look and revert.
>
> On Sun, Jul 6, 2025 at 5:09 PM Ben Caspi <benc(at)aidoc(dot)com> wrote:
>
>> Hi,
>>
>> In the past we reached out to you about the PostgreSQL Windows
>> installer not having an option to modify the locale on installation,
>> resulting in failures during upgrades due to mismatched locale versions.
>>
>> As a result you released installer version 15.13, which included a more
>> inclusive locale flag which solves our problem.
>>
>> However, we recently noticed that when picking a locale starting with
>> "English", the value post installation will always be "English_United
>> States.1252".
>>
>> For example, we installed using locale "English, United Kingdom" and
>> expected the locale value post installation to be "English_United
>> Kingdom.1252". However, we saw it was installed with the "English_United
>> States.1252" locale instead.
>>
>> We then tested multiple different locales and found this issue repeats
>> only when choosing locales starting with "English".
>>
>> Is this the intended behavior? If not, we would appreciate a fix to this
>> issue as it's blocking us from upgrading our machines holding older
>> PostgreSQL versions.
>>
>> Thank you!
>>
>> --
>>
>> [image: photo]
>>
>> Ben Caspi
>> DevOps Engineer
>>
>> www.aidoc.com | benc(at)aidoc(dot)com
>>
>> [image: linkedin] <https://www.linkedin.com/company/aidoc/>
>>
>> [image: twitter] <https://twitter.com/aidocmed>
>>
>> [image: App Banner Image] <https://www.aidoc.com/book-a-demo/>
>>
>>
>
>
> --
> Sandeep Thakkar
>
>
>

--
Sandeep Thakkar

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Laurenz Albe 2025-07-09 15:17:54 Re: Unexpected behavior when setting "idle_replication_slot_timeout"
Previous Message Robin Haberkorn 2025-07-09 11:28:58 Re: BUG #18943: Return value of a function 'xmlBufferCreate' is dereferenced at xpath.c:177 without checking for NUL