Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p1oBo-0006K4-Py for pgsql-general@arkaria.postgresql.org; Sun, 04 Dec 2022 12:33:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p1oBn-0006zj-Dx for pgsql-general@arkaria.postgresql.org; Sun, 04 Dec 2022 12:33:47 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p1oBn-0006zZ-2z for pgsql-general@lists.postgresql.org; Sun, 04 Dec 2022 12:33:47 +0000 Received: from mout.gmx.net ([212.227.15.19]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p1oBh-0006gf-F3 for pgsql-general@lists.postgresql.org; Sun, 04 Dec 2022 12:33:46 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=s31663417; t=1670157220; bh=D8XJ6g4eb89UMvc1TeJZTyc9Em/mXF79biU12kDP3Vs=; h=X-UI-Sender-Class:Date:From:To:Subject:References:In-Reply-To; b=jJfoaAC1n0sysCMxWAk50CmiIecSPqEsVZL7PxQBzoyU4Js91qZRiz1a2l2AjgLAe mZpwAD7gQyC5d6UAOHqjzuOq1tTHFlUUfM5xcs7NWVSUMC/R08mDtweiLPm9os8cDp O7Wh3aNeoSWX7jVHSkUtZYA1T1OwZH+WNim6l6KZ1HXcfeLt5c2j6Gb0vkKvQy79pt Dw7AwCHBIiuSHy8HnUi8PeX5jXWECGmH6bgJK9IrgvhOQEmP7uZOIIwzEtHilIve/Y zpv4s3i0FPv1ta4kk0zHm3vg0jOdzSBOmlsLivqM8P3VuRjPlZUnCGs02JsGGc/Qjt JtlQO701tLQ/w== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from hermes ([84.144.201.66]) by mail.gmx.net (mrgmx004 [212.227.17.190]) with ESMTPSA (Nemesis) id 1MxDkw-1omKdw1YHw-00xaYD for ; Sun, 04 Dec 2022 13:33:40 +0100 Received: from ncq by hermes with local (Exim 4.94.2) (envelope-from ) id 1p1oBf-0008E9-Eg for pgsql-general@lists.postgresql.org; Sun, 04 Dec 2022 13:33:39 +0100 Date: Sun, 4 Dec 2022 13:33:39 +0100 From: Karsten Hilbert To: pgsql-general@lists.postgresql.org Subject: Re: Q: error on updating collation version information Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: Ma_X_il-Followup-to: d Re_X_turn-receipt-to: Karsten.Hilbert@gmx.net Di_X_sposition-Notification-To: Karsten.Hilbert@gmx.net X-Confi_X_rm-Reading-To: Karsten.Hilbert@gmx.net X-Pri_X_ority: 2 (High) Sender: X-Provags-ID: V03:K1:3VuMs+tnIEjnJ7IqCjsu8pKpgAQ9lYE9UbhdsDzwMaiE657zrci 8gHPGZrsmqj9KrIQfXNEBXQ6IfhqAlNnHy4OBRNwahved3pCSZCaEBEv/T3owkEJ4JO4HsC 6yhqq+2rX9ve+tPKBUb5mz4yyXbiLfZWty+tGfdwts5MoZixsDItHf8BWst/QaQuKgKNNFM tL8G913/QdgtzObDLbZyA== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:CIAX5hZQHVY=;G9te+akkQdUuNIQvs1t7/LYBYSl M/b5lBBKeODqh+i4eSh5KjwQ5lFSguaTW5uNCl5azwB34c4L3c1Dr0s3IbGRg9ahvJkwUSXeu jeOxsQUJ8P8oR+4jT/3tfgKDLWpBI5EWp0xCrL7yiQSfcSBSMVURSqiLGt97ngpzbr8rReubC 1tXMV3Hx3ouslUIy497BpmizBUAf8hvEuDczQxyiwBZdBgYofiD7wvFayS0y0oiKwKCXcgDIh IajK5CuMcdtqTeoLc31KI9fb65mzCKnNm2FjNd5H3EV7FIalBMOeio0cnzPlm0+iYakx78PyR xVn7n+RRW1pATjm37YxbSDzAK8Eeyz8qnRxKXjzmx4e9F05EtYybycrQcRprLneP9hhIdNQyI W40H8rPUFa1maNmFc0EruZdCzIuXIQpuanlozJ3wrmUIEGhu5GImMYJ6BNZNcqxJNm5hrJ58D gnyiksashE3clBhYWEPGfGIuMZMxP2KxZ9Yz4ISwL4lJIFYeVK4nxcnA69EsHYA71kEosaaqh FaDx3/i+jEeaJYlamWd9MgUHXjdSsJJkZosdtCjgXeeHOxYyCz0VDPDpSE2R9EqTVadKId+x7 GGj1yqg9yDpt4jDz7Uy8kqxB7iX1F79r4OMRMXf61hfe/jiApHZd6TTeCkKElDdVZv2XOIMAp 5o/ukyVJBbpCmydSzp1+UfGRXo8AlOrgNyVl6Io53kNPJ0TcLw5s+xMWzCO/lkkvwkWz1XpRf 6U3/HYHgi3dIyjp95aHETdbAKJTTCKfiXCRdvSgB41MR8O/jf5GfM020HGJsearchMC1tL+MP ojOuAdByZAXRxpPI7E3HJR7obn2GYdWF4ziuwxHFCxam0mqX4109HZMNPqEeK1IemwJjTx6Gt bROGS17Q5/hpMkQ/z9cfXAL7ny3JMiRLqmoR6HkMGoY6E5A5p544C0hhdULTY26dL2h1O4FMS iRoPBw== Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Am Sun, Dec 04, 2022 at 01:22:02PM +0100 schrieb Karsten Hilbert: > gnumed_v22=3D> ALTER COLLATION pg_catalog."br_FR@euro" REFRESH VERSION; > ERROR: collation "pg_catalog.br_FR@euro" for encoding "UTF8" does not = exist The OS (libc) does seem to know that collation: @hermes:~$ locale -a | grep br_FR br_FR br_FR@euro br_FR.utf8 Karsten =2D- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B