Message-ID: <439075fc-508e-3a3b-2310-632c57cb897f@ardentperf.com>
Date: Tue, 7 Jun 2022 14:13:51 -0700
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0)
 Gecko/20100101 Thunderbird/91.9.1
Subject: Re: Collation version tracking for macOS
Content-Language: en-US
To: Peter Geoghegan <pg@bowt.ie>
Cc: Robert Haas <robertmhaas@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>,
 Thomas Munro <thomas.munro@gmail.com>,
 Peter Eisentraut <peter.eisentraut@enterprisedb.com>,
 pgsql-hackers <pgsql-hackers@postgresql.org>
References: <381977b1-0898-cb6f-a427-3b5d873e81bd@enterprisedb.com>
 <CA+hUKGKjkL=APm5nd3vGOtMAD_07nyvrbAaGaDduVD-EKM5Drw@mail.gmail.com>
 <ce1174ea-1942-37f0-421e-9ccff400dbcb@enterprisedb.com>
 <231072.1654273317@sss.pgh.pa.us>
 <1874de62-6bec-4bc1-1d14-0a2730b125da@ardentperf.com>
 <CA+hUKGLwT9xBSodtmio-NnGXfkrfVs02O6kg1iwBJSt-XMhW4g@mail.gmail.com>
 <366234.1654289888@sss.pgh.pa.us>
 <CA+TgmoZyjoRMj=m2s2a=Hvxp05aAwectjUeSP0Nf67Jsz8-cEA@mail.gmail.com>
 <CAH2-WzmXFVw6wAtgLo+0ggin===9TOG8OZC9VorHCu9W7y4Kew@mail.gmail.com>
 <bb4e241c-c591-b2dd-0283-9e1ee5a6c7da@ardentperf.com>
 <CAH2-WzkZCUbdJ+E1bE1tvsoA4Ceh=qLgz-eeFqbFB0=AmwKu=A@mail.gmail.com>
From: Jeremy Schneider <schneider@ardentperf.com>
In-Reply-To: 
 <CAH2-WzkZCUbdJ+E1bE1tvsoA4Ceh=qLgz-eeFqbFB0=AmwKu=A@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/439075fc-508e-3a3b-2310-632c57cb897f%40ardentperf.com>
Precedence: bulk

On 6/7/22 1:51 PM, Peter Geoghegan wrote:
> On Tue, Jun 7, 2022 at 1:24 PM Jeremy Schneider
> <schneider@ardentperf.com> wrote:
>> This idea does seem to persist. It's not as frequent as timezones, but
>> collation rules reflect local dialects and customs, and there are
>> changes quite regularly for a variety of reasons. A brief perusal of
>> CLDR changelogs and CLDR jiras can give some insight here:
> 
>> Another misunderstanding that seems to persist is that this only relates
>> to exotic locales or that it's only the 2.28 version.
> 
> I'm not defending the status quo, and I think that I'm better informed
> than most about the problems in this area. My point was that it hardly
> matters that we don't necessarily see outright corruption. This was
> based in part on a misunderstanding of Tom's point, though.


I think I was guilty of the same misunderstanding - apologies Tom!
Thanks Peter for calling that out explicitly.

For my for my part, gut feeling is that MacOS major releases will be
similar to any other OS major release, which may contain updates to
collation algorithms and locales. ISTM like the same thing PG is looking
for on other OS's to trigger the warning. But it might be good to get an
official reference on MacOS, if someone knows where to find one?  (I don't.)

-Jeremy


-- 
http://about.me/jeremy_schneider