Message-ID: <862ddcbc-ba23-0312-afee-973b00a257e8@joeconway.com>
Date: Tue, 29 Nov 2022 14:34:03 -0500
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.2.2
Content-Language: en-US
To: Jeff Davis <pgsql@j-davis.com>, Robert Haas <robertmhaas@gmail.com>,
 Thomas Munro <thomas.munro@gmail.com>
Cc: Peter Eisentraut <peter.eisentraut@enterprisedb.com>,
 Jeremy Schneider <schneider@ardentperf.com>, Peter Geoghegan <pg@bowt.ie>,
 "Finnerty, Jim" <jfinnert@amazon.com>, "Nasby, Jim" <nasbyj@amazon.com>,
 Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers <pgsql-hackers@postgresql.org>
References: <b37c2acd-24f4-07c9-da6e-6fec66137f69@enterprisedb.com>
 <D9EBBA4F-C92C-4B26-AB4D-6038BC52793D@ardentperf.com>
 <398aabd1-ad95-ba2d-d70a-dd5d90bf6e07@enterprisedb.com>
 <CA+hUKGL36vXMfcaDq+U1ZkoSsdfFnNx7GxhGM7aYzEbKs1W0=Q@mail.gmail.com>
 <CA+hUKGKq=iLH3bY+nK7v8b2zBCuKOk-fe0cP0it2RxNaWFVxYA@mail.gmail.com>
 <606bd2baa6d65b38fee6eb23bba40c5da210255b.camel@j-davis.com>
 <CA+hUKG+OSQtrRAk-bHwMJmuvqp-b-LGuxsF2PoDBVyQcT+VEAQ@mail.gmail.com>
 <9f8e9b5a3352478d4cf7d6c0a5dd7e82496be4b6.camel@j-davis.com>
 <CA+hUKGJxg6AbKC9RJ7r1ByVLtvVkThQV+RZO6BKVWYESPCp3Ug@mail.gmail.com>
 <CA+TgmoaTGBSLWYHA_TPz9Fc1TOa5aZ=2yXMrGbo9xU225Nv+YA@mail.gmail.com>
 <5ca35de8-48a6-6d9f-6f92-82d9da9ce227@joeconway.com>
 <9d70e95d78a05a9ba130db92a5b8a4f9c897f8b6.camel@j-davis.com>
From: Joe Conway <mail@joeconway.com>
Subject: Re: Collation version tracking for macOS
In-Reply-To: <9d70e95d78a05a9ba130db92a5b8a4f9c897f8b6.camel@j-davis.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/862ddcbc-ba23-0312-afee-973b00a257e8%40joeconway.com>
Precedence: bulk

On 11/29/22 13:59, Jeff Davis wrote:
> On Tue, 2022-11-29 at 11:27 -0500, Joe Conway wrote:
>> My vote is for something like #5. The collversion should indicate a 
>> specific immutable ordering behavior.
> 
> Easier said than done:
> https://www.postgresql.org/message-id/abddc35a7a447d93e2b8371a1a9052cb48866070.camel@j-davis.com
> 
> Even pointing at a specific minor version doesn't guarantee that
> specific ICU code is loaded. It could also be a mix of different minor
> versions that happen to be installed.

I understand that it is not easily done, but if the combination of 
collprovider + collversion does not represent specific immutable 
ordering behavior for a given locale, what value is there in tracking it?

-- 
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com