Content-Type: text/plain; charset="iso-8859-15"
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
Subject: Re: Built-in CTYPE provider
From: "Daniel Verite" <daniel@manitou-mail.org>
To: "Noah Misch" <noah@leadboat.com>
Cc: Peter Eisentraut <peter@eisentraut.org>,
 Jeff Davis
 <pgsql@j-davis.com>,
 Robert Haas <robertmhaas@gmail.com>,
 Jeremy Schneider <schneider@ardentperf.com>,
 pgsql-hackers@postgresql.org
In-Reply-To: <20240702230333.8d.nmisch@google.com>
Date: Fri, 05 Jul 2024 13:55:40 +0200
Message-Id: <41c3fa3f-e0bf-4d79-8af3-ef2fd7d56c2e@manitou-mail.org>
Archived-At: 
 <https://www.postgresql.org/message-id/41c3fa3f-e0bf-4d79-8af3-ef2fd7d56c2e%40manitou-mail.org>
Precedence: bulk

	Noah Misch wrote:

> > I don't think the builtin locale provider is any different in this resp=
ect
> > from the other providers:  The locale data might change and there is a
> > version mechanism to track that.  We don't prevent pg_upgrade in scenar=
ios
> > like that for other providers.
>=20
> Each packager can choose their dependencies so the v16 providers don't ha=
ve
> the problem.  With the $SUBJECT provider, a packager won't have that opti=
on.

The Unicode data files downloaded into src/common/unicode/
depend on the versions defined in Makefile.global.in:

  # Unicode data information

  # Before each major release, update these and run make update-unicode.

  # Pick a release from here: <https://www.unicode.org/Public/>.  Note
  # that the most recent release listed there is often a pre-release;
  # don't pick that one, except for testing.
  UNICODE_VERSION =3D 15.1.0

  # Pick a release from here: <http://cldr.unicode.org/index/downloads>
  CLDR_VERSION =3D 45

(CLDR_VERSION is apparently not used yet).

When these versions get bumped, it seems like packagers could stick to
previous versions by just overriding these.
When doing that, are there any function that may have an immutability
breakage problem with the built-in locale provider? (I would expect none).


Best regards,
--=20
Daniel V=E9rit=E9
https://postgresql.verite.pro/
Twitter: @DanielVerite