public inbox for [email protected]
help / color / mirror / Atom feedFrom: Jeff Davis <[email protected]>
To: Thomas Munro <[email protected]>
To: Jeremy Schneider <[email protected]>
Cc: Peter Eisentraut <[email protected]>
Cc: Peter Geoghegan <[email protected]>
Cc: Nasby, Jim <[email protected]>
Cc: Tom Lane <[email protected]>
Cc: pgsql-hackers <[email protected]>
Subject: Re: Collation version tracking for macOS
Date: Tue, 29 Nov 2022 11:03:39 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <CA+hUKG+g-AFta22P0NjuFTbi3jywWTqR+dyExQwu5Vr=mSeXUw@mail.gmail.com>
References: <[email protected]>
<[email protected]>
<[email protected]>
<CA+hUKGL36vXMfcaDq+U1ZkoSsdfFnNx7GxhGM7aYzEbKs1W0=Q@mail.gmail.com>
<CA+hUKGKq=iLH3bY+nK7v8b2zBCuKOk-fe0cP0it2RxNaWFVxYA@mail.gmail.com>
<[email protected]>
<CA+hUKG+OSQtrRAk-bHwMJmuvqp-b-LGuxsF2PoDBVyQcT+VEAQ@mail.gmail.com>
<[email protected]>
<CA+hUKGJxg6AbKC9RJ7r1ByVLtvVkThQV+RZO6BKVWYESPCp3Ug@mail.gmail.com>
<[email protected]>
<CA+hUKGJhPeW3iRqO3XQB=+BTMx7O6zTCFKTfeSV9TXBtdyMqbQ@mail.gmail.com>
<CA+hUKGLr=9d+-k8PVv8e__TOxuq=n0SKNDpqCzbGrK5EbDyxAg@mail.gmail.com>
<[email protected]>
<[email protected]>
<CA+hUKG+g-AFta22P0NjuFTbi3jywWTqR+dyExQwu5Vr=mSeXUw@mail.gmail.com>
On Wed, 2022-11-30 at 07:18 +1300, Thomas Munro wrote:
> On Wed, Nov 30, 2022 at 7:03 AM Jeremy Schneider
> <[email protected]> wrote:
> > It seems to me that the collator_version field is not a good
> > version
> > identifier to use.
> >
> > Just taking a quick glance at the ICU home page right now, it shows
> > that
> > all of the last 5 versions of ICU have included "additions and
> > corrections" to locale data itself, including 68 to 69 where the
> > collator version did not change.
> >
> > Is it possible that this "collator_version" only reflects the code
> > that
> > processes collation data to do comparisons/sorts, but it does not
> > reflect updates to the locale data itself?
>
> I think it also includes the CLDR version for *some* locales. From a
> quick look, that includes 'ar', 'ru', 'tr', 'zh'. Jeff, would you
> mind sharing the same table for one of those? Perhaps 'en' really
> does depend only on the UCA?
=# select * from pg_icu_collation_versions('ar') order by icu_version;
icu_version | uca_version | collator_version
-------------+-------------+------------------
50.2 | 6.2 | 58.0.0.50
51.3 | 6.2 | 58.0.0.50
52.2 | 6.2 | 58.0.0.50
53.2 | 6.3 | 137.51.25
54.2 | 7.0 | 137.56.26
55.2 | 7.0 | 153.56.27.1
56.2 | 8.0 | 153.64.28
57.2 | 8.0 | 153.64.29
58.3 | 9.0 | 153.72.30.3
59.2 | 9.0 | 153.72.31.1
60.3 | 10.0 | 153.80.32.1
61.2 | 10.0 | 153.80.33
62.2 | 11.0 | 153.88.33.8
63.2 | 11.0 | 153.88.34
64.2 | 12.1 | 153.97.35.8
65.1 | 12.1 | 153.97.36
66.1 | 13.0 | 153.14.36.8
67.1 | 13.0 | 153.14.37
68.2 | 13.0 | 153.14.38.8
69.1 | 13.0 | 153.14.39
70.1 | 14.0 | 153.112.40
(21 rows)
=# select * from pg_icu_collation_versions('zh') order by icu_version;
icu_version | uca_version | collator_version
-------------+-------------+------------------
50.2 | 6.2 | 58.0.0.50
51.3 | 6.2 | 58.0.0.50
52.2 | 6.2 | 58.0.0.50
53.2 | 6.3 | 137.51.25
54.2 | 7.0 | 137.56.26
55.2 | 7.0 | 153.56.27.1
56.2 | 8.0 | 153.64.28
57.2 | 8.0 | 153.64.29
58.3 | 9.0 | 153.72.30.3
59.2 | 9.0 | 153.72.31.1
60.3 | 10.0 | 153.80.32.1
61.2 | 10.0 | 153.80.33
62.2 | 11.0 | 153.88.33.8
63.2 | 11.0 | 153.88.34
64.2 | 12.1 | 153.97.35.8
65.1 | 12.1 | 153.97.36
66.1 | 13.0 | 153.14.36.8
67.1 | 13.0 | 153.14.37
68.2 | 13.0 | 153.14.38.8
69.1 | 13.0 | 153.14.39
70.1 | 14.0 | 153.112.40
(21 rows)
--
Jeff Davis
PostgreSQL Contributor Team - AWS
view thread (137+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: Collation version tracking for macOS
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox