Re: PostgreSQL Windows Installer defaults to "English_United States.1252" when choosing locale starting with "English" - Mailing list pgsql-bugs

From Sandeep Thakkar
Subject Re: PostgreSQL Windows Installer defaults to "English_United States.1252" when choosing locale starting with "English"
Date
Msg-id CANFyU954kdQvv_21tJbdGv6qE3B=ZRbBa-bF21dJUAFmrNiJ2A@mail.gmail.com
Whole thread Raw
List pgsql-bugs
Hi,

I'll have a look and revert. 

On Sun, Jul 6, 2025 at 5:09 PM Ben Caspi <benc@aidoc.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!

--

photo

Ben Caspi
DevOps Engineer

www.aidoc.com  |  benc@aidoc.com

linkedin

twitter

App Banner Image

 


--
Sandeep Thakkar


pgsql-bugs by date:

Previous
From: Yura Sokolov
Date:
Subject: Re: BUG #18801: JIT recompiles function for each row if custom aggregation function is used
Next
From: Tom Lane
Date:
Subject: Re: BUG #18980: Unable to perform make due to inability to resolve a variety of Undefined symbols arm64