Re: COLLATION update in 13.1 - Mailing list pgsql-general

From Matthias Apitz
Subject Re: COLLATION update in 13.1
Date
Msg-id CAHzebO92PxW=e2FLN=ZSkMEvfoS+c-b9YKQNgj0Y3hj21pMw+A@mail.gmail.com
Whole thread Raw
In response to Re: COLLATION update in 13.1  (Jeremy Schneider <schneider@ardentperf.com>)
Responses Re: COLLATION update in 13.1
List pgsql-general
Thanks for your hint, Jeremy. But this does not work either:

postgres=# SELECT collname, collversion FROM pg_collation where collname = 'de_DE.utf8';
  collname  | collversion
------------+-------------
 de_DE.utf8 | 2.38
(1 row)

postgres=# ALTER COLLATION de_DE.utf8 REFRESH VERSION;
ERROR:  schema "de_de" does not exist

What do I wrong?

Matthia

On Mon, Feb 24, 2025 at 11:32 AM Jeremy Schneider <schneider@ardentperf.com> wrote:
On Mon, 24 Feb 2025 11:08:43 +0100
Matthias Apitz <gurucubano@googlemail.com> wrote:

>
> What is the procedure on 13.1 to bring the external (glibc) version
> in sync with. the used version in the PostgreSQL database?

If I recall correctly, between versions 10 and 14 you need to use ALTER
COLLATION name REFRESH VERSION on every collation where there's a
version mismatch. (This can happen with ICU collations since version 10,
and with glibc collations since version 13.)

I only know of a small number of changes between glibc versions 2.31 and
2.38 ~ I suspect you already know to look out for glibc 2.28 which was
the crazy one. (SLE15 Service Pack 3.) Most databases would be
corrupted by that update, and running "refresh version" would simply
stop the warnings without fixing the corruption.

-Jeremy

pgsql-general by date:

Previous
From: Jeremy Schneider
Date:
Subject: Re: COLLATION update in 13.1
Next
From: Dominique Devienne
Date:
Subject: Re: COLLATION update in 13.1