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+hUKGJ4o9Xw_Na7NdvvmoY7X1GyfZm=Hto9HjgTd9v83p0rRg@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>
 <CA+hUKGKa+22oiAs!
 KcBTzxzsMtFw4MedjiBESO2nS2FndNaHjPA@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>
 <1046810.1604440349@sss.pgh.pa.us>
 <CA+hUKGLyCG6CXzq8ScKp6XHiL8mfuE6XpMVDSJcCiJ0FauZR-A@mail.gmail.com>
 <CA+hUKGJ4o9Xw_Na7NdvvmoY7X1GyfZm=Hto9HjgTd9v83p0rRg@mail.gmail.com>
Comments: In-reply-to Thomas Munro <thomas.munro@gmail.com>
	message dated "Wed, 04 Nov 2020 14:20:45 +1300"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1099313.1604453607.1@sss.pgh.pa.us>
Date: Tue, 03 Nov 2020 20:33:27 -0500
Message-ID: <1099314.1604453607@sss.pgh.pa.us>
Precedence: bulk

Thomas Munro <thomas.munro@gmail.com> writes:
> I can't bring myself to commit that, it's not really in the spirit of
> this data integrity feature, and it's not our business to second guess
> the relationship between different locale naming schemes through fuzzy
> logic.  Instead, I propose to just neuter the feature if Windows
> decides it can't understand a locale names that it gave us.  It should
> still work fine with something like initdb --lc-collate=en-US.  Here's
> an untested patch.  Thoughts?

Works for me, at least as a short-term solution.

			regards, tom lane