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>
 <CAHzebO8SMasPTACdMASnSXY29WzuOEe1GBW+xgqBOn6pf+mPrQ@mail.gmail.com> <e76418437b70ceb69d39b3e65fc0a05c31308aea.camel@cybertec.at>
In-Reply-To: <e76418437b70ceb69d39b3e65fc0a05c31308aea.camel@cybertec.at>
From: Matthias Apitz <gurucubano@googlemail.com>
Date: Mon, 24 Feb 2025 13:07:06 +0100
Message-ID: <CAHzebO9fq5eRsoQZnzDiR=MDCOYo+eHmQ05Firo17zZg=6p06w@mail.gmail.com>
Subject: Re: COLLATION update in 13.1
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Dominique Devienne <ddevienne@gmail.com>, Jeremy Schneider <schneider@ardentperf.com>, 
	pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000085a2c9062ee22e6a"
Archived-At: <https://www.postgresql.org/message-id/CAHzebO9fq5eRsoQZnzDiR%3DMDCOYo%2BeHmQ05Firo17zZg%3D6p06w%40mail.gmail.com>
Precedence: bulk

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

Thanks. I did \l before which gives:

                                                  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            |
...

But why the ALTER statement needs the spelling different as the output of
\l :

sisis=3D# ALTER COLLATION "de_DE.UTF-8" REFRESH VERSION;
ERROR:  collation "de_DE.UTF-8" for encoding "UTF8" does not exist

sisis=3D# ALTER COLLATION "de_DE.utf8" REFRESH VERSION;
NOTICE:  version has not changed
ALTER COLLATION

?


On Mon, Feb 24, 2025 at 12:57=E2=80=AFPM Laurenz Albe <laurenz.albe@cyberte=
c.at>
wrote:

> On Mon, 2025-02-24 at 12:53 +0100, Matthias Apitz wrote:
> > 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?
>
> That REINDEX is certainly correct, even though it rebuilds way more
> indexes than necessary.
>
> If the ALTER COLLATION statement is correct or not depends on the
> collation you are using.  You could look at "\l" and "pg_collation"
> to get the name right.
>
> Yours,
> Laurenz Albe
>
> --
>
> *E-Mail Disclaimer*
> Der Inhalt dieser E-Mail ist ausschliesslich fuer den
> bezeichneten Adressaten bestimmt. Wenn Sie nicht der vorgesehene Adressat
> dieser E-Mail oder dessen Vertreter sein sollten, so beachten Sie bitte,
> dass jede Form der Kenntnisnahme, Veroeffentlichung, Vervielfaeltigung
> oder
> Weitergabe des Inhalts dieser E-Mail unzulaessig ist. Wir bitten Sie, sic=
h
> in diesem Fall mit dem Absender der E-Mail in Verbindung zu setzen.
>
> *CONFIDENTIALITY NOTICE & DISCLAIMER
> *This message and any attachment are
> confidential and may be privileged or otherwise protected from disclosure
> and solely for the use of the person(s) or entity to whom it is intended.
> If you have received this message in error and are not the intended
> recipient, please notify the sender immediately and delete this message
> and
> any attachment from your system. If you are not the intended recipient, b=
e
> advised that any use of this message is prohibited and may be unlawful,
> and
> you must not copy this message or attachment or disclose the contents to
> any other person.
>

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

<div dir=3D"ltr"><div>Thanks. I did \l before which gives:</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 databases<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 | Locale 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>But why the ALTER statement =
needs the spelling different as the output of \l :</div><div><br></div><div=
>sisis=3D# ALTER COLLATION &quot;de_DE.UTF-8&quot; REFRESH VERSION;<br>ERRO=
R: =C2=A0collation &quot;de_DE.UTF-8&quot; for encoding &quot;UTF8&quot; do=
es not exist<br></div><div><br></div><div>sisis=3D# ALTER COLLATION &quot;d=
e_DE.utf8&quot; REFRESH VERSION;<br>NOTICE: =C2=A0version has not changed<b=
r>ALTER COLLATION</div><div><br></div><div>?</div><div><br></div></div><br>=
<div class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"=
gmail_attr">On Mon, Feb 24, 2025 at 12:57=E2=80=AFPM Laurenz Albe &lt;<a hr=
ef=3D"mailto:laurenz.albe@cybertec.at">laurenz.albe@cybertec.at</a>&gt; wro=
te:<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">On Mon, 2025=
-02-24 at 12:53 +0100, Matthias Apitz wrote:<br>
&gt; If I understand the other reply from Laurenz Albe right, the correct p=
rocedure would be:<br>
&gt; <br>
&gt; pgsql -Usisis sisis<br>
&gt; sisis=3D# REINDEX (VERBOSE) DATABASE sisis;<br>
&gt; sisis=3D# ALTER COLLATION &quot;de_DE.utf8&quot; REFRESH VERSION;<br>
&gt; ALTER COLLATION<br>
&gt; <br>
&gt; Correct?<br>
<br>
That REINDEX is certainly correct, even though it rebuilds way more<br>
indexes than necessary.<br>
<br>
If the ALTER COLLATION statement is correct or not depends on the<br>
collation you are using.=C2=A0 You could look at &quot;\l&quot; and &quot;p=
g_collation&quot;<br>
to get the name right.<br>
<br>
Yours,<br>
Laurenz Albe<br>
<br>
-- <br>
<br>
*E-Mail Disclaimer*<br>
Der Inhalt dieser E-Mail ist ausschliesslich fuer den <br>
bezeichneten Adressaten bestimmt. Wenn Sie nicht der vorgesehene Adressat <=
br>
dieser E-Mail oder dessen Vertreter sein sollten, so beachten Sie bitte, <b=
r>
dass jede Form der Kenntnisnahme, Veroeffentlichung, Vervielfaeltigung oder=
 <br>
Weitergabe des Inhalts dieser E-Mail unzulaessig ist. Wir bitten Sie, sich =
<br>
in diesem Fall mit dem Absender der E-Mail in Verbindung zu setzen.<br>
<br>
*CONFIDENTIALITY NOTICE &amp; DISCLAIMER<br>
*This message and any attachment are <br>
confidential and may be privileged or otherwise protected from disclosure <=
br>
and solely for the use of the person(s) or entity to whom it is intended. <=
br>
If you have received this message in error and are not the intended <br>
recipient, please notify the sender immediately and delete this message and=
 <br>
any attachment from your system. If you are not the intended recipient, be =
<br>
advised that any use of this message is prohibited and may be unlawful, and=
 <br>
you must not copy this message or attachment or disclose the contents to <b=
r>
any other person.<br>
</blockquote></div>

--00000000000085a2c9062ee22e6a--