pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Thomas Munro <thomas.munro@gmail.com>
Cc: David Rowley <dgrowleyml@gmail.com>
Cc: Julien Rouhaud <rjuju123@gmail.com>
Cc: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Cc: Michael Paquier <michael@paquier.xyz>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Douglas Doole <dougdoole@gmail.com>
Cc: Christoph Berg <myon@debian.org>
Cc: Pg Hackers <pgsql-hackers@postgresql.org>
Cc: Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
Subject: Re: Collation versioning
Date: Tue, 03 Nov 2020 20:33:27 -0500
Message-ID: <1099314.1604453607@sss.pgh.pa.us> (raw)
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>

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





view thread (188+ messages)  latest in thread

Message-ID: <1099314.1604453607@sss.pgh.pa.us>
Permalink:  ../1099314.1604453607@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/1099314.1604453607@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: tgl@sss.pgh.pa.us, thomas.munro@gmail.com, dgrowleyml@gmail.com, rjuju123@gmail.com, peter.eisentraut@2ndquadrant.com, michael@paquier.xyz, robertmhaas@gmail.com, laurenz.albe@cybertec.at, dougdoole@gmail.com, myon@debian.org, juanjo.santamaria@gmail.com
  Subject: Re: Collation versioning
  In-Reply-To: <1099314.1604453607@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox