Re: Collation version tracking for macOS - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: Collation version tracking for macOS
Date
Msg-id cac43a3baf43cec6138dcc1d3eaf7b572b7b1f4c.camel@j-davis.com
Whole thread Raw
In response to Re: Collation version tracking for macOS  (Thomas Munro <thomas.munro@gmail.com>)
Responses Re: Collation version tracking for macOS
List pgsql-hackers
On Wed, 2022-11-30 at 10:29 +1300, Thomas Munro wrote:
> On Wed, Nov 30, 2022 at 9:59 AM Jeff Davis <pgsql@j-davis.com> wrote:
> > Here's what I found for the 'ar' locale (firstminor/lastminor are
> > the
> > icu library versions, firstcollversion/lastcollversion are their
> > respective collation versions for the given locale):
> >
> >  firstminor | lastminor | firstcollversion | lastcollversion
> > ------------+-----------+------------------+-----------------
> >  60.1       | 60.3      | 153.80.32        | 153.80.32.1
> >  64.1       | 64.2      | 153.96.35        | 153.97.35.8
> >  68.1       | 68.2      | 153.14.38        | 153.14.38.8
> > (3 rows)
>
> Right, this fits with what I said earlier: the third component is
> CLDR
> major, fourth component is CLDR minor except from ICU 61 on the CLDR
> minor is << 3'd (X.X.38.8 means CLDR 38.1).

What about 64.1 -> 64.2? That changed the *second* component from 96 ->
97. Are we agreed that collations can materially change in minor ICU
releases?


--
Jeff Davis
PostgreSQL Contributor Team - AWS





pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Introduce a new view for checkpointer related stats
Next
From: Michael Paquier
Date:
Subject: Re: Add LZ4 compression in pg_dump