MIME-Version: 1.0
References: <B927CE6F-0A36-4237-BD4D-75CD609F3E89@gmail.com>
 <20240919174349.grrz4w25jmxfk77a@hjp.at> <58CD40AA-6316-40B6-89C2-390D16FF5FA0@gmail.com>
 <20240920223316.muvdgqekzh6dvcii@hjp.at> <DA5B67BD-F5EB-4566-B8C4-AFBBB0753CF4@gmail.com>
 <b281ad68-efb5-40d3-b03b-5d7c1e111914@joeconway.com>
In-Reply-To: <b281ad68-efb5-40d3-b03b-5d7c1e111914@joeconway.com>
From: Shaheed Haque <shaheedhaque@gmail.com>
Date: Sun, 22 Sep 2024 14:59:34 +0100
Message-ID: <CAHAc2jdOR=MRKW9=a7AUcFvViXOQDXKHp_FLzSLstLy=_voYqQ@mail.gmail.com>
Subject: Re: glibc updarte 2.31 to 2.38
To: Joe Conway <mail@joeconway.com>
Cc: Paul Foerster <paul.foerster@gmail.com>, "Peter J. Holzer" <hjp-pgsql@hjp.at>, 
	pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000003afb9d0622b5af24"
Archived-At: <https://www.postgresql.org/message-id/CAHAc2jdOR%3DMRKW9%3Da7AUcFvViXOQDXKHp_FLzSLstLy%3D_voYqQ%40mail.gmail.com>
Precedence: bulk

--0000000000003afb9d0622b5af24
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

I've been working on Unix-like systems for decades and though I thought I
understood most of the issues to do with i18n/l10n, I've only just started
using Postgres and I don't understand is why these changes ONLY seem to
affect Postgres. Or is it more that it also affects text editors and the
like, but we just tend to ignore that?

On Sun, 22 Sep 2024, 14:47 Joe Conway, <mail@joeconway.com> wrote:

> On 9/21/24 15:19, Paul Foerster wrote:
> > I already expressed the idea of changing all locales to ICU. The
> > problem there is that I'd have to create new instances and then move
> > each database individually. I wish I could convert already running
> > databases=E2=80=A6 This also takes time. Still, I think I'm going to tr=
y
> > this route. It's always a gamble if reindexing is needed or not with
> > any glibc change.
>
>
> Note that moving to ICU might improve things, but there are similar
> potential issues with ICU as well. The trick there would be to get your
> OS distro provider to maintain the same ICU version across major
> versions of the distro, which is not the case currently. Nor does the
> PGDG repo do that.
>
>
> --
> Joe Conway
> PostgreSQL Contributors Team
> RDS Open Source Databases
> Amazon Web Services: https://aws.amazon.com
>
>
>

--0000000000003afb9d0622b5af24
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<p dir=3D"ltr">I&#39;ve been working on Unix-like systems for decades and t=
hough I thought I understood most of the issues to do with i18n/l10n, I&#39=
;ve only just started using Postgres and I don&#39;t understand is why thes=
e changes ONLY seem to affect Postgres. Or is it more that it also affects =
text editors and the like, but we just tend to ignore that? </p>
<br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Sun=
, 22 Sep 2024, 14:47 Joe Conway, &lt;<a href=3D"mailto:mail@joeconway.com">=
mail@joeconway.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote=
" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">O=
n 9/21/24 15:19, Paul Foerster wrote:<br>
&gt; I already expressed the idea of changing all locales to ICU. The<br>
&gt; problem there is that I&#39;d have to create new instances and then mo=
ve<br>
&gt; each database individually. I wish I could convert already running<br>
&gt; databases=E2=80=A6 This also takes time. Still, I think I&#39;m going =
to try<br>
&gt; this route. It&#39;s always a gamble if reindexing is needed or not wi=
th<br>
&gt; any glibc change.<br>
<br>
<br>
Note that moving to ICU might improve things, but there are similar <br>
potential issues with ICU as well. The trick there would be to get your <br=
>
OS distro provider to maintain the same ICU version across major <br>
versions of the distro, which is not the case currently. Nor does the <br>
PGDG repo do that.<br>
<br>
<br>
-- <br>
Joe Conway<br>
PostgreSQL Contributors Team<br>
RDS Open Source Databases<br>
Amazon Web Services: <a href=3D"https://aws.amazon.com" rel=3D"noreferrer n=
oreferrer" target=3D"_blank">https://aws.amazon.com</a><br>
<br>
<br>
</blockquote></div>

--0000000000003afb9d0622b5af24--