From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robert Haas <robertmhaas@gmail.com>
cc: Thomas Munro <thomas.munro@gmail.com>,
        Jeremy Schneider <schneider@ardentperf.com>,
        Peter Eisentraut <peter.eisentraut@enterprisedb.com>,
        pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: Collation version tracking for macOS
In-reply-to: 
 <CA+TgmoZyjoRMj=m2s2a=Hvxp05aAwectjUeSP0Nf67Jsz8-cEA@mail.gmail.com>
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>
Comments: In-reply-to Robert Haas <robertmhaas@gmail.com>
	message dated "Tue, 07 Jun 2022 15:36:45 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1311646.1654631585.1@sss.pgh.pa.us>
Date: Tue, 07 Jun 2022 15:53:05 -0400
Message-ID: <1311647.1654631585@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1311647.1654631585%40sss.pgh.pa.us>
Precedence: bulk

Robert Haas <robertmhaas@gmail.com> writes:
> In fact, I'd go so far as to argue that you're basically sticking your
> head in the sand here. You wrote:

No, I quite agree that we have a problem.  What I don't agree is that
issuing a lot of false-positive warnings is a solution.  That will
just condition people to ignore the warnings, and then when their
platform really does change behavior, they're still screwed.  If we
could *accurately* report collation behavioral changes, I'd be all
for that.

Rod's idea upthread is certainly way too simplistic, but could we
build a set of test cases that do detect known changes in collation
behaviors?  We'd be shooting at a moving target; but even if we're
late in noticing that platform X changed the behavior of collation Y,
we could help users who run in the problem afterwards.

			regards, tom lane