Re: COLLATION update in 13.1

[Dominique Devienne <ddevienne@xxxxxxxxx>]

On Mon, Feb 24, 2025 at 12:33 PM Matthias Apitz <gurucubano@xxxxxxxxxxxxxx> 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;