Re: COLLATION update in 13.1

From: Dominique Devienne <ddevienne(at)gmail(dot)com>
To: Matthias Apitz <gurucubano(at)googlemail(dot)com>
Cc: Jeremy Schneider <schneider(at)ardentperf(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: COLLATION update in 13.1
Date: 2025-02-24 11:35:40
Message-ID: CAFCRh--NUP9-g08QDiCX2Yntqea1tPMk01OgYOD7uhsAja==VQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Feb 24, 2025 at 12:33 PM Matthias Apitz <gurucubano(at)googlemail(dot)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;

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2025-02-24 11:41:05 Re: COLLATION update in 13.1
Previous Message Matthias Apitz 2025-02-24 11:32:57 Re: COLLATION update in 13.1