Horton

Re: COLLATION update in 13.1

Dominique Devienne <ddevienne@gmail.com>

View thread View on postgr.es
From: Dominique Devienne <ddevienne@gmail.com>
To: Matthias Apitz <gurucubano@googlemail.com>
Cc: Jeremy Schneider <schneider@ardentperf.com>, pgsql-general@lists.postgresql.org
Date: 2025-02-24T11:35:40Z
Lists: pgsql-general 
On Mon, Feb 24, 2025 at 12:33 PM Matthias Apitz <gurucubano@googlemail.com>
wrote:

> 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?
>

Missing quotes.  ALTER COLLATION "de_DE.utf8" REFRESH VERSION;