Horton

Re: [EXTERNAL] Re: Windows Application Issues | PostgreSQL | REF # 48475607

Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>

View thread
From: Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
To: Andrew Dunstan <andrew@dunslane.net>
Cc: Thomas Munro <thomas.munro@gmail.com>, "Haifang Wang (Centific Technologies Inc)" <v-haiwang@microsoft.com>, Rahul Pandey <pandeyrah@microsoft.com>, Vishwa Deepak <Vishwa.Deepak@microsoft.com>, Shawn Steele <Shawn.Steele@microsoft.com>, Amy Wishnousky <amyw@microsoft.com>, Tom Lane <tgl@sss.pgh.pa.us>, "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>, Shweta Gulati <gulatishweta@microsoft.com>, Ashish Nawal <nawalashish@microsoft.com>
Date: 2024-07-22T12:12:41Z
Lists: pgsql-bugs

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Reject non-ASCII locale names.

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?
>
>
> I responded to it at
https://www.postgresql.org/message-id/CANFyU95Le%2BtrZbtB1D4Y1FdUu4y_OJLxvJMi1Zb9WOWuf8KpqA%40mail.gmail.com
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