Re: [EXTERNAL] Re: Windows Application Issues | PostgreSQL | REF # 48475607 - Mailing list pgsql-bugs

From Sandeep Thakkar
Subject Re: [EXTERNAL] Re: Windows Application Issues | PostgreSQL | REF # 48475607
Date
Msg-id CANFyU963Cf1RK0AZ99muoKWCZKGB0+RTMVeZ5J57upksR1qgnQ@mail.gmail.com
Whole thread Raw
In response to Re: [EXTERNAL] Re: Windows Application Issues | PostgreSQL | REF # 48475607  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: [EXTERNAL] Re: Windows Application Issues | PostgreSQL | REF # 48475607
List pgsql-bugs
Hi

On Mon, Jul 22, 2024 at 4:54 PM Andrew Dunstan <andrew@dunslane.net> wrote:


On 2024-07-21 Su 6:00 PM, Thomas Munro wrote:
One new-to-me fact from the -general mailing list this morning[1] is
that the EDB installer is explicitly feeding these unstable locale
names into the world's database clusters, so that's something that's
beyond the power of us upstream PostgreSQL hackers to fix even if we
pulled the trigger on the initdb BCP47-by-default patch[2].  Something
for someone at EDB to look into?

[1] https://www.postgresql.org/message-id/flat/CA%2BhUKGJA4pGEeZtfUUEuQmNNO7x16wZ%2BRWOeXP%2Btq3Hf4iu8oQ%40mail.gmail.com#6426ff9fd44fbcd9a7f343a3f94ae364
[2] https://www.postgresql.org/message-id/flat/CA+hUKGJ=XThErgAQRoqfCy1bKPxXVuF0=2zDbB+SxDs59pv7Fw@mail.gmail.com


Sandeep, can you comment?


When I checked the installation log shared by Ertan at https://github.com/EnterpriseDB/edb-installers/issues/127, I see installer is using the correct locale name while doing initdb.

Executing C:\Windows\System32\cscript //NoLogo "C:\Program Files\PostgreSQL\16/installer/server/initcluster.vbs" "NT AUTHORITY\NetworkService" "postgres" "****" "C:\Users\User1\AppData\Local\Temp/postgresql_installer_cd79fad8b7" "C:\Program Files\PostgreSQL\16" "C:\DATA_PG16" 5432 "Turkish,Türkiye" 0

Thomas, I can generate the test installer with your patch and share here so this issue can be tested before the minor release?

cheers


andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com


--
Sandeep Thakkar


pgsql-bugs by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: [EXTERNAL] Re: Windows Application Issues | PostgreSQL | REF # 48475607
Next
From: Tom Lane
Date:
Subject: Re: BUG #18546: Attempt to insert default into a non-updatable column of a view fails with a dubious error