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-07 12:20:40
Message-ID: CANFyU954kdQvv_21tJbdGv6qE3B=ZRbBa-bF21dJUAFmrNiJ2A@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2025-07-07 21:04:15 BUG #18980: Unable to perform make due to inability to resolve a variety of Undefined symbols arm64
Previous Message Yura Sokolov 2025-07-07 10:02:45 Re: BUG #18801: JIT recompiles function for each row if custom aggregation function is used