Message-ID: <56dbe5984c26ff2ebda5f3c607389a0416ae9d7f.camel@cybertec.at>
Subject: Re: COLLATION update in 13.1
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Matthias Apitz <gurucubano@googlemail.com>
Cc: Dominique Devienne <ddevienne@gmail.com>, Jeremy Schneider
	 <schneider@ardentperf.com>, pgsql-general@lists.postgresql.org
Date: Mon, 24 Feb 2025 16:10:06 +0100
In-Reply-To: <CAHzebO9fq5eRsoQZnzDiR=MDCOYo+eHmQ05Firo17zZg=6p06w@mail.gmail.com>
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>
	 <CAHzebO9fq5eRsoQZnzDiR=MDCOYo+eHmQ05Firo17zZg=6p06w@mail.gmail.com>
User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) 
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/56dbe5984c26ff2ebda5f3c607389a0416ae9d7f.camel%40cybertec.at>
Precedence: bulk

On Mon, 2025-02-24 at 13:07 +0100, Matthias Apitz wrote:
> Thanks. I did \l before which gives:
>=20
> =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
> =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 Prov=
ider | =C2=A0 Access privileges
> ------------+----------+----------+-------------+-------------+----------=
--+-----------------+-----------------------
> =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|
> =C2=A0customers =C2=A0| sisis =C2=A0 =C2=A0| UTF8 =C2=A0 =C2=A0 | de_DE.U=
TF-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|
> ...
>=20
> But why the ALTER statement needs the spelling different as the output of=
 \l :
>=20
> sisis=3D# ALTER COLLATION "de_DE.UTF-8" REFRESH VERSION;
> ERROR: =C2=A0collation "de_DE.UTF-8" for encoding "UTF8" does not exist
>=20
> sisis=3D# ALTER COLLATION "de_DE.utf8" REFRESH VERSION;
> NOTICE: =C2=A0version has not changed
> ALTER COLLATION

Yes, that is annoying.  You can use other collation names in CREATE DATABAS=
E
than the ones in pg_collation.  You have to choose the name that is used in
pg_collation, which is probably "de_DE.utf8".

Really, they refer to the same collation.

Yours,
Laurenz Albe

--=20

*E-Mail Disclaimer*
Der Inhalt dieser E-Mail ist ausschliesslich fuer den=20
bezeichneten Adressaten bestimmt. Wenn Sie nicht der vorgesehene Adressat=
=20
dieser E-Mail oder dessen Vertreter sein sollten, so beachten Sie bitte,=20
dass jede Form der Kenntnisnahme, Veroeffentlichung, Vervielfaeltigung oder=
=20
Weitergabe des Inhalts dieser E-Mail unzulaessig ist. Wir bitten Sie, sich=
=20
in diesem Fall mit dem Absender der E-Mail in Verbindung zu setzen.

*CONFIDENTIALITY NOTICE & DISCLAIMER
*This message and any attachment are=20
confidential and may be privileged or otherwise protected from disclosure=
=20
and solely for the use of the person(s) or entity to whom it is intended.=
=20
If you have received this message in error and are not the intended=20
recipient, please notify the sender immediately and delete this message and=
=20
any attachment from your system. If you are not the intended recipient, be=
=20
advised that any use of this message is prohibited and may be unlawful, and=
=20
you must not copy this message or attachment or disclose the contents to=20
any other person.