Message-ID: <6fec1a3a681623941c514e9ae0d97f42af417209.camel@j-davis.com>
Subject: Re: Collation version tracking for macOS
From: Jeff Davis <pgsql@j-davis.com>
To: Thomas Munro <thomas.munro@gmail.com>
Cc: Robert Haas <robertmhaas@gmail.com>, 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>
Date: Tue, 29 Nov 2022 16:25:36 -0800
In-Reply-To: 
 <CA+hUKGJrt9V80++wPfNSyJ8RTHaGRfBnzVzg5v-ejxS15P5znA@mail.gmail.com>
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>
	 <83faecb4a89dfb5794938e7b4d9f89daf4c5d631.camel@j-davis.com>
	 <CA+TgmoYU0SmLYAFQRecgox8Pgn3qRDvrSokEH9jn=+6_jB5Rxg@mail.gmail.com>
	 <abddc35a7a447d93e2b8371a1a9052cb48866070.camel@j-davis.com>
	 <df679394b4656e8687c68ec8470bb20ba2876196.camel@j-davis.com>
	 <CA+hUKGJrt9V80++wPfNSyJ8RTHaGRfBnzVzg5v-ejxS15P5znA@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.44.4-0ubuntu1 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/6fec1a3a681623941c514e9ae0d97f42af417209.camel%40j-davis.com>
Precedence: bulk

On Wed, 2022-11-30 at 10:52 +1300, Thomas Munro wrote:
> On Wed, Nov 30, 2022 at 8:38 AM Jeff Davis <pgsql@j-davis.com> wrote:
> > On Tue, 2022-11-29 at 10:46 -0800, Jeff Davis wrote:
> > > One bit of weirdness is that I may have found another ICU
> > > problem.
> >=20
> > Reported as:
> >=20
> > https://unicode-org.atlassian.net/browse/ICU-22216
>=20
> I'm no expert on loader/linker arcana but I have a feeling this is a
> dead end.=C2=A0 It's an ancient Unix or at least elf-era Unix convention
> that SONAMEs have major versions only, because major versions are the
> basis of ABI stability.

It's possible that it's more a problem of how they are doing it: the
specific version is coming from a dependency rather than the library
itself. The results are surprising, so I figured it's worth a report.
Let's see what they say.

Regardless, even if they did make a change, it's not going to help us
anytime soon. We can't rely on any scheme that involves multiple minor
versions for a single major version being installed at once. That means
that, if you create a collation depending on ICU X.Y, and then it gets
upgraded to X.(Y+1), and you create another collation depending on that
library version, you are stuck.


--=20
Jeff Davis
PostgreSQL Contributor Team - AWS