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 1p1zl4-0004zO-EX for pgsql-general@arkaria.postgresql.org; Mon, 05 Dec 2022 00:54:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p1zkz-0002d1-Ms for pgsql-general@arkaria.postgresql.org; Mon, 05 Dec 2022 00:54:53 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p1zkz-0002cq-CW for pgsql-general@lists.postgresql.org; Mon, 05 Dec 2022 00:54:53 +0000 Received: from mout.gmx.net ([212.227.15.15]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p1zks-0003cg-L5 for pgsql-general@lists.postgresql.org; Mon, 05 Dec 2022 00:54:52 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=s31663417; t=1670201679; bh=WohXJ9Ux1Cxg3x5KzkncQ50BPhykW48p39iFEohbqq4=; h=X-UI-Sender-Class:Date:From:To:Cc:Subject:References:In-Reply-To; b=PC34NgOM9ZAXY6JJ7yY8effZnVY7sjXe2oxUKLJVfv/or/9BAWbkwkVMtMNHN8dJi Ttb8EEO3mRWZSJVr9YrcoWr93NKdD0/lKtF/VH/tpFtgEFwSugfkWZpSmV2YygtI/X EoMnWzcqAkFTIC92wLTnw+h56HYnZY65rNp2j4EvhpNeiJQeE/EHkSuXJz9EBwRp/6 qZL7nkTGERdgVcq2U3IXcG1TJlTon2t1Af8Yh4BuODiqp+q2GUeGjKt0VcxbMR8tR+ h4ozZSjWXnJZZ6g07gufhRt8cvDhF1DpXOMr/VVyxYKC+m85hQSpCJ5ZGVjZRDZkJv L7SXoNy2UXOsQ== 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 1Mqs4Z-1ofuUY0vuz-00mu6z; Mon, 05 Dec 2022 01:54:39 +0100 Received: from ncq by hermes with local (Exim 4.94.2) (envelope-from ) id 1p1zkj-0004C5-Ey; Mon, 05 Dec 2022 01:54:37 +0100 Date: Mon, 5 Dec 2022 01:54:37 +0100 From: Karsten Hilbert To: Adrian Klaver Cc: pgsql-general@lists.postgresql.org Subject: Re: Q: error on updating collation version information Message-ID: References: <954702a5-3552-640e-6df9-a03ab5fbc339@aklaver.com> 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:m5/uaOHHZESe6nAFsX1+QW0MZbr9JXhFQRwTimRgt3QIkeysoZ7 XiAYgjqc5whJSYiCsvMH+PkZ5QGSkjT72s4NrjavrkZ8RpvolEFny1iHEW4Mcrjcg9EExL/ End4u4wfMuPzE00dYWYaarwmDBzrrJ11/wCbFSSvhkb/InXuirv5IsW5gCxdeWvBcCiueaV aeMu3C0X58HmxGThX7gSQ== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:cBQWDaNwGz4=;iyHpiGC9W131q2Bz6dw+3Zn8P36 Di9J9/Uhqqv6fmI361Pp40suJ72kmqzq+/E/w9LFo/f1G9HlyoKbg7sXCegUjAmM0onmxV1Qs B9t9B/tk/2eEd83vXCFZJqFGIwPWyM0qfAQsnxnTIRo4JswhoMPAoqgwXaLFEDbegH+yIFDkL 7cN9g0xPAW4Lad6y0Tbu+Ak570L9P48zjen23Cg5/JSHilQEHsL/rPt6l2WwTsfVmgkBscidX lrR72/NOBYLOZTNVJ/uQ52HvMXD/r1w5xzPdZ9JttE4qEf6L+PxrjVnR3/Bsw26jTG0GCKvMp DKb9I+/ZMPwQ3Ll1ES40WI6+SdYok2b4B8/R7ofCDmyPLuj7+P9y7L/3CDfNtCL+v7g2MU/4L ghBVFpALu01rDl9RWxiKxH6P8sOrEKxTJpzvI8T0YIZgkcR3pvA3uGjoQxFV4DJ6caRsreTec Z2JqlethifzYlZEl2gXurZ8dTk8M0koJ2foGQXPg0QQHK165edxFZTCCb7JI9sLOowBPuQHab yVRL+YxkoZQ8SeLbwOa7BETNbVQvjtdMex/PQ4IidRe90+XVTXGf6xkrBv1KnFt1S22D45Rr9 rerH4XtIJ50ytfY+1/c8xNhTbi3u5yJW1R+YKonyPgkfeOWeydvsFtd94Atn3aHOFtfrmwHeX ctIcFu1iGZXFOIStK2lFCScUiJ+68iPM53KtbyGsC1ynCmLP2OgprYIRQ7fBx2nNZRhUBUU08 qfXvp/8W2gF9DuPG4emX16gdVfImbcSDwpoaggCQtsiyzI0Ebc6eQs3R7iyeQhWwhaqllyaLJ lgaB06K1pPjjJQlPY2GH6CiGUr/3OBavERGoPCCm7ndMOq8+R6GLRL6NNg3f7nV0niqnoDvbb yzM8FvmaIBNUCgRXNo/7p5ewPYOJRNIEkW72E1aI/6kutoENKfx0DkRm61YNXLQiu5bmz3C/D NyE13Q== Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Is this to be expected ? PG 15.1 on Debian: gnumed_v22=3D# select *, pg_collation_actual_version(oid), pg_encoding_to= _char(collencoding) from pg_collation where collname =3D 'zh_TW'; -[ RECORD 1 ]---------------+------------ oid | 12985 collname | zh_TW collnamespace | 11 collowner | 10 collprovider | c collisdeterministic | t collencoding | 4 collcollate | zh_TW.euctw collctype | zh_TW.euctw colliculocale | collversion | 2.35 pg_collation_actual_version | 2.36 pg_encoding_to_char | EUC_TW -[ RECORD 2 ]---------------+------------ oid | 12986 collname | zh_TW collnamespace | 11 collowner | 10 collprovider | c collisdeterministic | t collencoding | 6 collcollate | zh_TW.utf8 collctype | zh_TW.utf8 colliculocale | collversion | 2.36 pg_collation_actual_version | 2.36 pg_encoding_to_char | UTF8 gnumed_v22=3D# begin; BEGIN gnumed_v22=3D*# alter collation pg_catalog."zh_TW" refresh version ; NOTICE: version has not changed ALTER COLLATION gnumed_v22=3D*# alter collation pg_catalog."zh_TW.utf8" refresh version ; NOTICE: version has not changed ALTER COLLATION gnumed_v22=3D*# alter collation pg_catalog."zh_TW.euctw" refresh version = ; ERROR: collation "pg_catalog.zh_TW.euctw" for encoding "UTF8" does not e= xist gnumed_v22=3D!# As far as I can tell the documentation asserts that since the database encoding is UTF8 the pg_catalog."zh_TW.euctw" will be ignored by the server for all practical purposes. Does this mean it is impossible to "correct" its version information ? And if so, that is expected to be non-harmful and is not expected to trigger nag messages ? Thanks, Karsten =2D- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B