Thanks. I tried a lot of combinations. Based on the output of \l
List of databases
Name | Owner | Encoding | Collate | Ctype | ICU Locale
| Locale Provider | Access privileges
------------+----------+----------+-------------+-------------+------------+-----------------+-----------------------
bar | foo | UTF8 | de_DE.UTF-8 | de_DE.UTF-8 |
| libc |
customers | sisis | UTF8 | de_DE.UTF-8 | de_DE.UTF-8 |
| libc |
...
postgres=# ALTER COLLATION "de_DE.UTF8" REFRESH VERSION;
ERROR: collation "de_DE.UTF8" for encoding "UTF8" does not exist
yours (Dominique) seems to work:
postgres=# ALTER COLLATION "de_DE.utf8" REFRESH VERSION;
NOTICE: version has not changed
ALTER COLLATION
If I understand the other reply from Laurenz Albe right, the correct
procedure would be:
pgsql -Usisis sisis
sisis=# REINDEX (VERBOSE) DATABASE sisis;
sisis=# ALTER COLLATION "de_DE.utf8" REFRESH VERSION;
ALTER COLLATION
Correct?
On Mon, Feb 24, 2025 at 12:35 PM Dominique Devienne <ddevie...@gmail.com>
wrote:
> On Mon, Feb 24, 2025 at 12:33 PM Matthias Apitz <gurucub...@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;
>
