MIME-Version: 1.0
References: <CAHzebO-2qy2RkrhTvqPs8=6Ju_6-7C=MSumVMZxTs7zRYp-6mA@mail.gmail.com>
 <20250224023225.197cac12@ardentperf.com> <CAHzebO92PxW=e2FLN=ZSkMEvfoS+c-b9YKQNgj0Y3hj21pMw+A@mail.gmail.com>
 <CAFCRh--NUP9-g08QDiCX2Yntqea1tPMk01OgYOD7uhsAja==VQ@mail.gmail.com>
In-Reply-To: <CAFCRh--NUP9-g08QDiCX2Yntqea1tPMk01OgYOD7uhsAja==VQ@mail.gmail.com>
From: Matthias Apitz <gurucubano@googlemail.com>
Date: Mon, 24 Feb 2025 12:53:32 +0100
Message-ID: <CAHzebO8SMasPTACdMASnSXY29WzuOEe1GBW+xgqBOn6pf+mPrQ@mail.gmail.com>
Subject: Re: COLLATION update in 13.1
To: Dominique Devienne <ddevienne@gmail.com>
Cc: Jeremy Schneider <schneider@ardentperf.com>, pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000f3ac32062ee1fd93"
Archived-At: <https://www.postgresql.org/message-id/CAHzebO8SMasPTACdMASnSXY29WzuOEe1GBW%2BxgqBOn6pf%2BmPrQ%40mail.gmail.com>
Precedence: bulk

--000000000000f3ac32062ee1fd93
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=3D# ALTER COLLATION "de_DE.UTF8" REFRESH VERSION;
ERROR:  collation "de_DE.UTF8" for encoding "UTF8" does not exist

yours (Dominique) seems to work:

postgres=3D# 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=3D# REINDEX (VERBOSE) DATABASE sisis;
sisis=3D# ALTER COLLATION "de_DE.utf8" REFRESH VERSION;
ALTER COLLATION

Correct?


On Mon, Feb 24, 2025 at 12:35=E2=80=AFPM Dominique Devienne <ddevienne@gmai=
l.com>
wrote:

> On Mon, Feb 24, 2025 at 12:33=E2=80=AFPM Matthias Apitz <gurucubano@googl=
email.com>
> wrote:
>
>> Thanks for your hint, Jeremy. But this does not work either:
>>
>> postgres=3D# SELECT collname, collversion FROM pg_collation where collna=
me
>> =3D 'de_DE.utf8';
>>   collname  | collversion
>> ------------+-------------
>>  de_DE.utf8 | 2.38
>> (1 row)
>>
>> postgres=3D# 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;
>

--000000000000f3ac32062ee1fd93
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Thanks. I tried a lot of combinations. Based on the o=
utput of \l</div><div><br></div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 List of data=
bases<br>=C2=A0 =C2=A0 Name =C2=A0 =C2=A0| =C2=A0Owner =C2=A0 | Encoding | =
=C2=A0 Collate =C2=A0 | =C2=A0 =C2=A0Ctype =C2=A0 =C2=A0| ICU Locale | Loca=
le Provider | =C2=A0 Access privileges<br>------------+----------+---------=
-+-------------+-------------+------------+-----------------+--------------=
---------<br>=C2=A0bar =C2=A0 =C2=A0 =C2=A0 =C2=A0| foo =C2=A0 =C2=A0 =C2=
=A0| UTF8 =C2=A0 =C2=A0 | de_DE.UTF-8 | de_DE.UTF-8 | =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0| libc =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0|<br>=
=C2=A0customers =C2=A0| sisis =C2=A0 =C2=A0| UTF8 =C2=A0 =C2=A0 | de_DE.UTF=
-8 | de_DE.UTF-8 | =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| libc =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0|</div><div>...</div><div><br></div><div>=
postgres=3D# ALTER COLLATION &quot;de_DE.UTF8&quot; REFRESH VERSION;<br>ERR=
OR: =C2=A0collation &quot;de_DE.UTF8&quot; for encoding &quot;UTF8&quot; do=
es not exist</div><div><br></div><div>yours (Dominique) seems to work:</div=
><div><br></div><div>postgres=3D# ALTER COLLATION &quot;de_DE.utf8&quot; RE=
FRESH VERSION;<br>NOTICE: =C2=A0version has not changed<br>ALTER COLLATION<=
/div><div><br></div><div>If I understand the other reply from Laurenz Albe =
right, the correct procedure would be:</div><div><br></div><div>pgsql -Usis=
is sisis</div><div><pre>sisis=3D# REINDEX (VERBOSE) DATABASE sisis;<br>sisi=
s=3D# ALTER COLLATION &quot;de_DE.utf8&quot; REFRESH VERSION;<br>ALTER COLL=
ATION<br><br></pre><pre>Correct?</pre><pre><br></pre><br></div></div><br><d=
iv class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gm=
ail_attr">On Mon, Feb 24, 2025 at 12:35=E2=80=AFPM Dominique Devienne &lt;<=
a href=3D"mailto:ddevienne@gmail.com">ddevienne@gmail.com</a>&gt; wrote:<br=
></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;=
border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><=
div dir=3D"ltr">On Mon, Feb 24, 2025 at 12:33=E2=80=AFPM Matthias Apitz &lt=
;<a href=3D"mailto:gurucubano@googlemail.com" target=3D"_blank">gurucubano@=
googlemail.com</a>&gt; wrote:</div><div class=3D"gmail_quote"><blockquote c=
lass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px soli=
d rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div>Thanks for your =
hint, Jeremy. But this does not work either:</div><div><br></div><div>postg=
res=3D# SELECT collname, collversion FROM pg_collation where collname =3D &=
#39;de_DE.utf8&#39;;<br>=C2=A0 collname =C2=A0| collversion<br>------------=
+-------------<br>=C2=A0de_DE.utf8 | 2.38<br>(1 row)<br><br>postgres=3D# AL=
TER COLLATION de_DE.utf8 REFRESH VERSION;<br>ERROR: =C2=A0schema &quot;de_d=
e&quot; does not exist</div><div><br></div><div>What do I wrong?</div></div=
></blockquote><div><br></div><div>Missing quotes.=C2=A0 ALTER COLLATION &qu=
ot;de_DE.utf8&quot; REFRESH VERSION;</div></div></div>
</blockquote></div>

--000000000000f3ac32062ee1fd93--