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

@Sandeep Thakkar<mailto:sandeep(dot)thakkar(at)enterprisedb(dot)com>, I believe your question is to Thomas, is that right?

@Thomas Munro<mailto:thomas(dot)munro(at)gmail(dot)com> regarding the patch you shared previously, could you give some instruction on how to use it?

Thanks!
Haifang

From: Sandeep Thakkar <sandeep(dot)thakkar(at)enterprisedb(dot)com>
Sent: Thursday, September 5, 2024 4:47 AM
To: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
Cc: Haifang Wang (Centific Technologies Inc) <v-haiwang(at)microsoft(dot)com>; Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>; Andrew Dunstan <andrew(at)dunslane(dot)net>; Rahul Pandey <pandeyrah(at)microsoft(dot)com>; Vishwa Deepak <Vishwa(dot)Deepak(at)microsoft(dot)com>; Shawn Steele <Shawn(dot)Steele(at)microsoft(dot)com>; Amy Wishnousky <amyw(at)microsoft(dot)com>; pgsql-bugs(at)lists(dot)postgresql(dot)org; Shweta Gulati <gulatishweta(at)microsoft(dot)com>; Ashish Nawal <nawalashish(at)microsoft(dot)com>
Subject: Re: [EXTERNAL] Re: Windows Application Issues | PostgreSQL | REF # 48475607

On Thu, Sep 5, 2024 at 5:46 AM Thomas Munro <thomas(dot)munro(at)gmail(dot)com<mailto:thomas(dot)munro(at)gmail(dot)com>> wrote:
On Thu, Sep 5, 2024 at 12:07 PM Haifang Wang (Centific Technologies
Inc) <v-haiwang(at)microsoft(dot)com<mailto:v-haiwang(at)microsoft(dot)com>> wrote:
> Good to know that, Thomas. I'm asking our tester to try it. Will let you know.

To give a more serious response, I don't really expect anything
"simple" about this patch not to work on Windows, as I know that it it
rejects non-ASCII names as I showed (on all OSes), and I know that
compiles and passes our tests on all our 4 CI operating systems:

https://cirrus-ci.com/build/4941642090676224

Really what I'm looking for is (1) feedback on the approach, code and
comments, and thoughts about more complex scenarios I may have failed
to think about, including say, pg_dump, pg_upgrade etc operational
issues, which probably involves lots of previous experience with
PostgreSQL, (2) opinions on whether we should add a test for these
cases and how to put the utf-8 into a script (I'm confused about the
encoding of command line arguments), and (3) a nod from the EDB people
involved in distributing this software on Windows.

We can help with producing the builds with the patches provided. You had also
mentioned about the changes required in the installer script, will it still be required?

--
Sandeep Thakkar