public inbox for [email protected]
help / color / mirror / Atom feedFrom: Matthias Apitz <[email protected]>
To: Dominique Devienne <[email protected]>
Cc: Jeremy Schneider <[email protected]>
Cc: [email protected]
Subject: Re: COLLATION update in 13.1
Date: Mon, 24 Feb 2025 12:53:32 +0100
Message-ID: <CAHzebO8SMasPTACdMASnSXY29WzuOEe1GBW+xgqBOn6pf+mPrQ@mail.gmail.com> (raw)
In-Reply-To: <CAFCRh--NUP9-g08QDiCX2Yntqea1tPMk01OgYOD7uhsAja==VQ@mail.gmail.com>
References: <CAHzebO-2qy2RkrhTvqPs8=6Ju_6-7C=MSumVMZxTs7zRYp-6mA@mail.gmail.com>
<[email protected]>
<CAHzebO92PxW=e2FLN=ZSkMEvfoS+c-b9YKQNgj0Y3hj21pMw+A@mail.gmail.com>
<CAFCRh--NUP9-g08QDiCX2Yntqea1tPMk01OgYOD7uhsAja==VQ@mail.gmail.com>
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 <[email protected]>
wrote:
> On Mon, Feb 24, 2025 at 12:33 PM Matthias Apitz <[email protected]>
> 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;
>
view thread (13+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: COLLATION update in 13.1
In-Reply-To: <CAHzebO8SMasPTACdMASnSXY29WzuOEe1GBW+xgqBOn6pf+mPrQ@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox