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>
In-Reply-To: <CAHzebO92PxW=e2FLN=ZSkMEvfoS+c-b9YKQNgj0Y3hj21pMw+A@mail.gmail.com>
From: Dominique Devienne <ddevienne@gmail.com>
Date: Mon, 24 Feb 2025 12:35:40 +0100
Message-ID: <CAFCRh--NUP9-g08QDiCX2Yntqea1tPMk01OgYOD7uhsAja==VQ@mail.gmail.com>
Subject: Re: COLLATION update in 13.1
To: Matthias Apitz <gurucubano@googlemail.com>
Cc: Jeremy Schneider <schneider@ardentperf.com>, pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000690958062ee1be46"
Archived-At: <https://www.postgresql.org/message-id/CAFCRh--NUP9-g08QDiCX2Yntqea1tPMk01OgYOD7uhsAja%3D%3DVQ%40mail.gmail.com>
Precedence: bulk

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

On Mon, Feb 24, 2025 at 12:33=E2=80=AFPM Matthias Apitz <gurucubano@googlem=
ail.com>
wrote:

> Thanks for your hint, Jeremy. But this does not work either:
>
> postgres=3D# SELECT collname, collversion FROM pg_collation where collnam=
e =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;

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

<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">gurucubano@=
googlemail.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_co=
ntainer"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8e=
x;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"=
><div>Thanks for your hint, Jeremy. But this does not work either:</div><di=
v><br></div><div>postgres=3D# SELECT collname, collversion FROM pg_collatio=
n where collname =3D &#39;de_DE.utf8&#39;;<br>=C2=A0 collname =C2=A0| collv=
ersion<br>------------+-------------<br>=C2=A0de_DE.utf8 | 2.38<br>(1 row)<=
br><br>postgres=3D# ALTER COLLATION de_DE.utf8 REFRESH VERSION;<br>ERROR: =
=C2=A0schema &quot;de_de&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 &quot;de_DE.utf8&quot; REFRESH VERSION;</div></div></di=
v>

--000000000000690958062ee1be46--