Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wTPZM-000Vhe-1E for pgsql-admin@arkaria.postgresql.org; Sat, 30 May 2026 19:42:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wTPZK-006PbI-2p for pgsql-admin@arkaria.postgresql.org; Sat, 30 May 2026 19:42:03 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wTPZK-006Pb4-1D for pgsql-admin@lists.postgresql.org; Sat, 30 May 2026 19:42:02 +0000 Received: from mout.gmx.net ([212.227.17.22]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wTPZI-00000000JbV-0aOR for pgsql-admin@lists.postgresql.org; Sat, 30 May 2026 19:42:01 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1780170118; x=1780774918; i=shammat@gmx.net; bh=ush5n+uGCm+FsB0l0FN3r7+zrPoAp843r1d/qvL4LMU=; h=X-UI-Sender-Class:Message-ID:Date:MIME-Version:To:From:Subject: Content-Type:Content-Transfer-Encoding:cc: content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=sPoO9ms28QRxffgSVo3Tvndyi9F+SdwTxr1YNiW0RqFPzy3EP8v4v6B/3G/gaPZo kBiVaRoqda76glhFWJglUql2sGkZeKHRONSNaQSWtIIHJLhr3AHxtsflrCcpyQuFK qCFXcgh1XSDVjrNF2Y7RicAYYLn/HBaiqCfye0gA3EeUpsqX+sa5Dfc2cibRAJ1gI 1VeyALHJ1I28Ge32NexN0V9nBHKad5fxlCzEdxaFT9G9p7LOnaVkN+XwnNMuKSRL6 B6vkwyxxpee/iRaYgqUScncIUtpYe8jOmP4pZwDumFCGTVrVTvF/WZRBn7Yeug4Er 3FmLgRUGoP6aRs/+pA== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from client.hidden.invalid by mail.gmx.net (mrgmx105 [212.227.17.168]) with ESMTPSA (Nemesis) id 1M42nY-1wTPZF3il6-0074dJ for ; Sat, 30 May 2026 21:41:57 +0200 Message-ID: Date: Sat, 30 May 2026 21:41:56 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Content-Language: de-DE, en-US To: pgsql-admin@lists.postgresql.org From: shammat@gmx.net Subject: Collation changes Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K1:ihusE+DZH2TTeWmjlNV3wilKrcXVLO7yljBLfstu1SnMvg/HoHl zswGwlw4qpQefitPYRViGkII/rekhGeFBFBOuE0Lx1MSkA6huLoH4S/WrJU3Ij0/41WyIlm efACvGWazJpBdgZPYMEXnhITjBEDvngvKKm6J9z2ry09KsU74p5+mXunAjMRzSFV1X3x2/D X+WWZ5n4DfHU0RQpdPMmQ== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:kGxJBjxkVOk=;3mcqc0Ws+fH5NfO9eTzGFYP9Gbh E1YOveE+AwYJ3wIUd7oDc7t4fU8YKhn1qT0oq2HR4NIzuH5ACcGuFOSTqrZN/1GkT9Z6nMgZs mzV1Y5d77zTeoLUnvD0AmV7AjxK4uq2KSD2MgPAAL2pwW65O+PcssNvUoeEq5NaDc6NCkPdlz bH4lMjv4voWacUpzudQd6FQYL6D3CcEz7CP+H6bT+kEAXUKvKYOJhg+6KUdhNR9nEcEfnkKe9 JWRCJ6GWO58wTagqlqW61zlEcoFMsV5sR/lPBIBnxrBfhyFa6/p6iHpHt+wAwKsYibFcQqs25 iwcNZ2weluwdVr3vV5CsfYbB4ohiamU3/O5JFEKH6PrqNb1qiHyVE5LQiEATkI+yoAiry65jN 70OF3+DtzIuzOYKoztnZNB2I0BRbog80vpQa0gjmkHoPd2CQhEQlkVdr0chA4B6n4vgbuDRhD T4cG6UVcTLy7CZiY7uOlvLXNzY9KIHqu+NDDGPJTVJOogc/lg5f4X5acNeQ5F/BJoLPCUewWi cXkY7N5w5fDQfrc1By5h0tBWMESN7U6njJgEAS68Pn03ESokFJv8cGQkGSfd5WGiny1qQsfOQ 4+4odw+1OpYvHSFDulD5RAuI3jdbdtQdlsTRE1w5gVjgrbCFra0mUyRKzV1OWFTWm+dWBE5UA sfxjghNM/nYLxD7SQPqeD/1JkgplgdFdssxYFa9uqi9KM7DRQmmA1c3PauRco3fVhJ5flQWDV oatOtn3dure/MWb3Ae4tpVQnvELoSiHumkaQvC7nY/FVx0Pzu8htVvIoqUdkEg9GuyR3joFa0 RT1G0Nchpg0wRshHHzHJnoaBQQozA2AiKREDhid9Th2kc4UsFTSoo39vtE2TqYKD2ZhRAmAdN SiXPbIQzXL2mXHDW6NSsv3erqlDg1LZm2bivVLWjULjcIqRRTc++HipkDSbeyXaqkfTv1OlYF 3NgGGVahLnCDtOG3YWtVzHtmdVG2TiPvFr4dnhpQOSJfFtk4OICch/GCCCirGzHJXRn1mNixk 9Go2/uSDHNnLFkLpgkY0/SXyHGfPlTGuoLkkHgeZ1Dx16eghGh8t0P0KfCSf41qFq2Sz0avvA Inyt2pYdrESY2+7Qgn7fcpQgKO8NknOp2wxX0qL2QtNsKpicmdU4pRZZGokEajH7TOeEiUm5A +llxb55WNKJ5UgHN4tlk3N7BU9GMWj5N3KOcvFELFF0yLKRkA+gpaT+yp/vYtHe2uGJQoyvZW GWVvyyBUEHD822lsoVOnVVcb0wbK4Y0KPv8BHTbnFwa9k+0LSM5t9wT4dvKxe/OXTmt/XJwN5 NUPL5XQMu0aYZQiPKXFxOyfeax2ZS/wyV8e4D5M8MX6kS7CRr0Cin2jktdMDGTpRNYX0F+Wnk j4UgCo4MyMLc0m/wWB9hZ4K6XvR37TEcHV2He4JA0OdbZ+SyUXLb7/jWl3sbtxOOFfiZpfvpj iQIwB3YRKcf/ujx9d4USO6rdI+YYoyr2kp68XTjJe2G1mnNGND1SBAhqhp8G+SDP2D4f3TAAz A43pZN9ZgLtKY8Z9zt1MpckrR6JlhvMiMCAyF8YEBP474cZ2h0IL2+SiXNp+uVrvblRuq6m45 mbYh5ld3hMKaxVigw23jN+mCI8fNzvQtd5IkrHPqtwhOvaJ8ujhqTeOQG15PPu7spDfMeHSO9 kuexT5A6opUH9IX8tw79JmooMDoFq54G9MyIgXmLy+awOfNfXYbqbyQFHuBzrM+NkBcWI4bpn j/YjmNrsO94zsmDZLKf3g3ZxtLZrU6ttegDjjca1zvzHwG5ChUkqgVCErP4PfsztgwIxsWmcY HXVww0jsJgtOq0/OkP48RMPPc/T6dJ75i3XCENinPWZcLMPa2wvjKg1izfKnRE77htZey/mkL Jfh3Aroqn0OilpzEc+fsf0kSy87CVX+na0PG2+czcYe83urRQNmHH8OBaguizRq9cMXE3mEJf 6ISBmfwIzxMuIR2Fa9693IAM7tEukL6fTSb7SzQ2cwPnveKQsVp9tQwdDXiBW6lVvZYFC6Twg g9xtSYiPpXlvVkdiJYB9FH9rCQd4jTbR5xu7RYAl4wdOVP+aaHGhGn8owk3FAz4td8ehbhML0 VtiRLqNWAWjOrRrv3mOYIe80rGCnYq8wj8YcNx0kabaobYanFDbzX2WRVOEFduZWrh9u0Xp7Z 3xyVSylbkZR3ztVy+iXTIIbL+d5dIdAy+un3cNGIwvmslTJUpTJogGhOIzyFHnW9JZqVteL0M GBZDeiLezHrGmLIAZHbd3W+lJWFHdI56eY9pp0oEW20EmVkN2jyWZPiOFgxLZGTSRC6ymqx0+ BNbPawKMfcPcAPzCQXYfi4j4ZSkUR9vTbliEt4Lz/Z7ayxUsQuS3lPEeWBkaKgm7x6Nc075ve QMCJf1iJzXv/ep3jCtLPE5PRR95TYmFFvqRcc1CTB0r5hMSz95D7pCjJmk0ZUPYFju0AflDDy DKqo3qi/XkMA3yeP4yBoVN3sONuSpwkddIDC8xLOgeznhyinP6q8+0EluSHO50zkQ214K8QG0 Au8VavTVmVMASCXizF8Jdw5vbpki2buNG37A7VGFmxnstdldNU0oKQxlb4X0jg9i70lZNkjqq Xmanhn+bhJzMFPm+nvjFTfom7zD4ghu+ZagasjHafLPa2kRIJI/xTY466s23HAtSS8JAvUgsM IsBm1XCl+m13qsFCrc5grNNA6ITqAp9cXcWR3b02prHG5eE9DwZH7ZX+k3Rn8cinijxilKgnX OGEmH09mK2qLCo5j2wP8KNEz3yr1XuDaSqNzv1T73Dp7xpC9dVkH3960doWEv5Ni24KSZaKth 43ELBhqmaOReu4TDrmUbRLW7/xJhxF0xA1Hvlfdv2dsuSqJE7YtkHgKD0hD54QaK94QoLuG+U OLFO8V6XMI2FOOKWV3bcKralJWNLLQytYA00vm+ZBMiwSSKKqefuS/CvcxoLUww3RwdrzHItb CTw3vOsO4cD9JaczpX+/RTJ3LwSbRvKDRFz6nmhLkvhe+cE2d79bePA9lTzJmjEKm9aHmuGai AWYUcSYTMIvTGRa6/exV6UmSjwQa/h4v45Q7dpPpbtZ/Y04lDOzl4DShhRWTmgX9mUQACzpHm tMHwHIVnNU63z7GWw7Pp5aLjMqKGuH8uNVWsyLVhZddNxGlKQ/Z5vZjBqTT7GlslWA++7uyp7 fTCyKj4vJNzBgmh63+mnimaIL/pLkB9jvvfupArxzrJJD91BvcdSo1OFSNe3GH1/Y6Wp1WckY FxGiJdH52KmLx8h+kzSopE0anb7Wk1x+xdaYT0ZFvzQlc4xnnGEgc/WuY/T/7LG2hEPGrgfnK V6j+db3GOMKRin5EI4EY08eik8DwSzQix6Ssq3hv/7HJGB0QHR3jJuLIFzPc6ojYCq5bhBbrL JnZSy9SkqEQWuawb/iPjJU84f1Uyb++0GFb3u2vzguLu4jiTOfH4i6bYAhBWfGDyUD5vdX2dT JWsBJ+AIBcP3I+BHElO9r3M4R2OI4u3w01gMM5fAxbKIqM9ekDcaMsOQkDUIitjXuP5cDHuQP iwhjmWa0jkR3hJR0ahehzLYmg62h4cspQZ/zkuLet0wgd2Nc0zW8kmGbx3kUCUC0Uw0uosYst qZ5/noTE1Ub84EREdriv5+pYqAt9SwkfxjoofAZazjRX5iyCTtrR3AL1lVfbghYZBip8w+eQi aAfQ69jZ05ZXf1QJ+CddIgTPZ0Z1QtmqsEblJG3dUqytnodrzoKIzoSA+AeeTQslJRF6/XjMP 0BtemTAcnDShkRAPzVhFOp8VWK+yYoW+v697XJGFm/gNgYCjXa81FEcvHtzq7XMyW6a12ojuz ubOv7iS5tTAaZWV8ZRkdeGosvG6cyw1vO7ZMOJWeLcS1CXDulz2ukSK4FdV61eiWdjd+VWTNu 2jOO7i+PuNIvajilYTVKPCk6xUDiw4xTFVoZW6wyGZXfFdhPbpT5KWF0CDgxz5KYRpQvK1IHv t6pAJNeTbQaBzpV/fHDdF1x0sdrGsWzd31srje8Hi4MJwlOXtORnnmau6nTrHnFLZnTvPFY32 H1wTS7RKiDuiNmepztmkmkhi09FmfwJq68flW5GRCQkEkNo3eOW2mZOap7ksmsvpvad8rvn7i eike/i5TbQtqZBEsvQoMGJ39kumnuhlTuXxxIuCHLFK3KWn9oHlRtKdSPK+aEobCfMCmAoJbX 0piMq18ed/shS4F/rrB4Y2uf0RxqHFUWO3FYUVHgFG1lfZkUfSJHGuvUMOv+FJ0hbTOg8jT1l lUvGjOm1apU1ostKU2afI8vXw0ao0Zo1SkiG43qkNZ/FV9yMMqsqXFHEhMdIuzBuzvNCnBVQw Osi9T9jxnYn49eSFAGeoE0hTX4HRDw5T6m5hTvWPjEnf39FXBChPYEZLVhBagn1XKm3s2KXCP reOYiMfTDbEl7rg96t00SnJv1MJ0Ojph7ZRmBWV3t0aeJB/oZhpc+SbkoKJgaxFJ9dXQakbRA +eyj3lWsIfkmVxiVDvfUZy1FX+yONmdzRZoi+HkcbCGTlDAEAAXsx9xpVoLezejVBqtGCtbgf UXMB4xQhZaigueKqZODufjpE9TxJVbo7xmqYrFIEp+FNHA5MNJJnnhBeO4n4m88x1SE7TFzsN 9x/D2O/aldGgJocOBKb05Bsv2adDmnjSy+fUD/8+R3hjkg+F0ZVO+pQnzM0QWMO0T/afIZbt3 psRhVUjW/+rfU757wMu1eLaQAZ18lmhBbRIHWEuipaWTiseDln/48gvykPZp3jWHilGi/y9un E0ARSYyWBbXbsWonfOEO5t2Ta1qtbi2RsREoMr7uiY4/pBltWnfUD0X1g4jwpot1dj+FREAHa wQc5c+Dqjp8KWT3l8my7gReOQa95CIod7BKT8306LSWoybjzVigibG3UIlvNpWgh4M0yRLiYc YaK1sg+QmdiE59s1g/Wis5ZgCGqSU3F/Pc5RRoAEJO2JHuoj0M78SNm8ui0qD7hBSr/b/9sC7 VZCsA62+J/KXjELzTulS0nLmbtOgYbVV+ZyiXPI997MGc4mmB1it+DBggfWgCcZBbNFpZtOho V04wakmnp4g++S2FpnBRB5B+zZcomUNen/97MAMhEl+ujDsbb0IRbELDjRdonNeOfDxAGVulC qUEPZiXFJ6v2Kvr10BZF798rr9BHw4jNkm/8UIi7oG28lOgnTpxxYg91ZnfbRNhJ6/RJCxAvZ iU/LPO6FN0vpzGWsZ6+ytWIqWQha9yBV3TBBDnhGYRhDQULFRAaXwLoFL+le/yZ4nFD+RUaLN 6OljXry4mZhqbq1vFc7yu3uuJCr9SEqw+JFv4LcM+Q== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello, I thought I had understood the problems with libc collation changes, but today a Fedora update showed me, that I probably did not :) After refreshing the encodings for the databases (and reindexing) I thought I'd have a look at the versions in pg_collation using the following query: select collname, collversion, pg_encoding_to_char(collencoding) as encoding, pg_collation_actual_version(oid) from pg_collation where collprovider = 'c' and collversion <> pg_collation_actual_version(oid) The query returned several hundred collations, all with a non UTF-8 encoding (mostly single byte encodings). Running "alter collation ... refresh version" on them resulted in NOTICE: version has not changed Which confuses me, as the above query showed collversion = 2.41 and pg_collation_actual_version() returned 2.43 Can someone clear up my confusion?