From: Tom Lane <tgl@sss.pgh.pa.us>
To: Thomas Munro <thomas.munro@gmail.com>
cc: David Rowley <dgrowleyml@gmail.com>, Julien Rouhaud <rjuju123@gmail.com>,
        Peter Eisentraut <peter.eisentraut@2ndquadrant.com>,
        Michael Paquier <michael@paquier.xyz>,
        Robert Haas <robertmhaas@gmail.com>,
        Laurenz Albe <laurenz.albe@cybertec.at>,
        Douglas Doole <dougdoole@gmail.com>, Christoph Berg <myon@debian.org>,
        Pg Hackers <pgsql-hackers@postgresql.org>,
        =?UTF-8?Q?Juan_Jos=C3=A9_Santamar=C3=ADa_Flecha?=
 <juanjo.santamaria@gmail.com>
Subject: Re: Collation versioning
In-reply-to: 
 <CA+hUKGKmcG6Khn7D59aDuUQkFLMvtN94SR2u_nBFMuRbPWWmXg@mail.gmail.com>
References: <20200813095204.f7mlgdzsbaxa3mzr@nol>
 <CA+hUKGLP-aW+K_PUCPbTy=g18yC=7UjurXXwiqYwTbtj3SwukA@mail.gmail.com>
 <20200814073746.GF2057@paquier.xyz> <20200814090235.ifld2qvaw43pzpzg@nol>
 <20200907031741.GK2455@paquier.xyz> <20200908144507.GA57691@nol>
 <c3324b4e-095d-8de9-c3ba-7b468bb5b0b4@2ndquadrant.com>
 <CAOBaU_ashTn3Hq2fQ7fZDaYy7yQSZEQnpTRHzfjOZPPyeKybow@mail.gmail.com>
 <CA+hUKGKop8pe3ijVna6ZUA3cGdjy8egm5geUuPJqM91smjLjYQ@mail.gmail.com>
 <CAOBaU_aauaDbKnSr8jhusOUoD0GiUQ79WRB+pun35Fx+_h66aQ@mail.gmail.com>
 <20200924094854.abjmpfqixq6xd4o5@nol>
 <CA+hUKGKHj4aYmmwKZdZjkD=CWRmn=e6UsS7S+u6oLrrp0orgsw@mail.gmail.com>
 <CAOBaU_b1nmVh4gbj4DG_+=o6cgNqOS_EvJTsGEp4M+DDB1rMtA@mail.gmail.com>
 <CA+hUKGLnLVQyi=6koWHSc+qnoDwvV8SfTXgO6VdJwJ7vCHtLUA@mail.gmail.com>
 <CAOBaU_aXmNQmS1HqM2TyG-TKaxW9dyEGHyTsGkR7-=2-+Zh=wA@mail.gmail.com>
 <CAOBaU_aOUHQ4nevV9Q6Gan2bDhMbGUdvwOe+o=XBJTp5ptoGcQ@mail.gmail.com>
 <CA+hUKGLgzE_KOFGnryYACHhaNp8XKCLZYcNFu+J=0rEt702TpQ@mail.gmail.com>
 <CAOBaU_YHbuMbwDN!
 NjCHcA6-qyRVeR1j6qFehA1gnz+bM3UZJNA@mail.gmail.com>
 <CA+hUKGKa+22oiAsKcBTzxzsMtFw4MedjiBESO2nS2FndNaHjPA@mail.gmail.com>
 <CAOBaU_a2s4kek+HELEkAa9Y5CA+W+2dS-e7F8K6BNWuh7=xaqg@mail.gmail.com>
 <CA+hUKGLWDWBL+79jNAz3oMofp1WDjQbBrmZTMe4E-b-MioQU0A@mail.gmail.com>
 <CAOBaU_ZYyxQ3sJR932NFs5HHh++RqXDGwe1S5ubBv8nmsHXCog@mail.gmail.com>
 <CA+hUKG+U_VV-7ZuJq0+sx5vwGYsUaeWSTxVUHc5ogeXJxJtAUw@mail.gmail.com>
 <686359.1604339499@sss.pgh.pa.us>
 <CA+hUKG+D8k_3GHX=0=Z53wDUaFGYu5RygA2tFn21KXR-K9j13g@mail.gmail.com>
 <CAApHDvpfOzs-tfm8wfiYg1zUZS0PDzNJG=rqnPHTfvks+G9ivg@mail.gmail.com>
 <CAApHDvq3FXpH268rt-6sD_Uhe7Ekv9RKXHFvpv==uh4c9OeHHQ@mail.gmail.com>
 <CA+hUKGKRDbQ9qGHt0SgE-1GbK+L6vAhCvBDQuA3naRXAQhhMyw@mail.gmail.com>
 <CA+hUKGKmcG6Khn7D59aDuUQkFLMvtN94SR2u_nBFMuRbPWWmXg@mail.gmail.com>
Comments: In-reply-to Thomas Munro <thomas.munro@gmail.com>
	message dated "Wed, 04 Nov 2020 10:48:24 +1300"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1046809.1604440349.1@sss.pgh.pa.us>
Date: Tue, 03 Nov 2020 16:52:29 -0500
Message-ID: <1046810.1604440349@sss.pgh.pa.us>
Precedence: bulk

Thomas Munro <thomas.munro@gmail.com> writes:
> On Tue, Nov 3, 2020 at 4:38 PM Thomas Munro <thomas.munro@gmail.com> wrote:
>> On Tue, Nov 3, 2020 at 1:51 PM David Rowley <dgrowleyml@gmail.com> wrote:
>>> FWIW, the attached does fix the issue for me.  It basically just calls
>>> the function that converts the windows-type "English_New Zealand.1252"
>>> locale name string into, e.g. "en_NZ".

> We want the same algorithm that Windows uses internally to resolve the
> old style name to a collation; in other words we probably want
> something more like the code path that they took away in VS2015 :-(.

Yeah.  In the short run, though, it'd be nice to un-break the buildfarm.
Maybe we could push David's code or something similar, and then
contemplate better ways at leisure?

			regards, tom lane