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 1ouJrL-0005ZL-9E for pgsql-general@arkaria.postgresql.org; Sun, 13 Nov 2022 20:45:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ouJrJ-00027b-2E for pgsql-general@arkaria.postgresql.org; Sun, 13 Nov 2022 20:45:41 +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 1ouJrI-00027S-HY for pgsql-general@lists.postgresql.org; Sun, 13 Nov 2022 20:45:40 +0000 Received: from mout.gmx.net ([212.227.15.18]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ouJrD-00047Q-T5 for pgsql-general@lists.postgresql.org; Sun, 13 Nov 2022 20:45:39 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=s31663417; t=1668372333; bh=Jvd6dWyneaBc88TzRaEuIRR96ql7B0zkc5F7nMcbQtc=; h=X-UI-Sender-Class:Date:From:To:Subject; b=PLNztQDJdXUbiKZKcSl2p/1OTstMv92KOemvRj5bmkbhRxEYP/kMSEfcs8Zl6BUe0 HrE/27OZmm7Efx1hEZxvfjaRRqy7wGFyQxNmNLMxwIQYHSX8rYY88tqojWp25jjZOM sOCKhj2dZ/+h3l5aYb3UbzdCBTsX2xJBh1Bx7xErdfAYq1rFVJ2TAJsaMdG4CD22mA W9TvdV0jxUWv9TDuq7fZl+S4DZehyh/x1pAedQU/PWrUUsxb1aflHk6BnXl+oyjGBF 5Fq2BSQaJb8A1xYYi2yrwsl+5RE5DMtbyBvx88wCO4GNDXCh81YsoYfposW179j7aw i05y2SnOA0Ckg== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from hermes ([91.9.16.86]) by mail.gmx.net (mrgmx004 [212.227.17.190]) with ESMTPSA (Nemesis) id 1MLi8g-1oceRp2lIu-00HeAk for ; Sun, 13 Nov 2022 21:45:33 +0100 Received: from ncq by hermes with local (Exim 4.94.2) (envelope-from ) id 1ouJrA-0004am-BO for pgsql-general@lists.postgresql.org; Sun, 13 Nov 2022 21:45:32 +0100 Date: Sun, 13 Nov 2022 21:45:32 +0100 From: Karsten Hilbert To: pgsql-general@lists.postgresql.org Subject: Q: fixing collation version mismatches Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline 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:zKyVES36+YP+fkwOs9M2ieqQUt2A8Km93U9kzs4kdQIQTlW+OgA +QT6kzYLf/qAW77zCUB1G9YhPBDhROrdTDbBkemdoLk5y2CSekIgUB4Tv1x9bDi1+PpOhQA 7AEK8DrVN7A9WZkXysmXCjupbe8lWkg5tJQJighZz/6sODJ8cM9avJQq3xCUFbJ6RxAQ9bY XmNBQq2+FDMMu9ZmDi4CQ== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:m16aTCcu9Zo=;mFkkWTW6Rhiz8E460bjWZwhtAO9 BfmnHl655sVdtniWmcOHNfk1EqX03dcC3Z2aYg87jGSV+ansKMmd6tNqef14VfCMSL5tELSV4 PfdDTeK8+dHDElbERKdntu5r7BCEWmnmCdDaAbSlkcJievJDCMYtdegILCyEhe3Rux+XPuT2m eTZqmeitQ+VtdLZLQEQLFOkctJiVOjHQ43AAf9FdtDYpdIY7bzR5MJnK3i+1lDOazOWQ6JxQs b6FthLhP9BAINrEIp/9Y3dTnghPQl/GIwEnppX7qAYIhYCOKWDKNqmDopggmx9x5fDLwhHXfY fb3Ml+kuoblnbWD05obWuX5K2JmoRClbL5JN48rDgbTu/WTiQfQG4W3xuRBQB7sJNdFqrOZu3 jyAYaYP8IinGWSNaO1fT2ADvrKfOmn00U83lFAQfVwcj8ecUZfvSIqmPrThAYsUPPn5Fg41E5 VVHuwjqa3SPrKWiyTSzWL4UH8cSFQF2MQbbVJzfVAWUa1TxytILuFsgiBfKA8nn9MYQaCBUIP 0ZGY5rxGJe2odt+7NTMt8OWEcIVwWwKRKAKJZWJ0IZQJv296hxksGTMnVCDlSUQpcZc3q0X4/ UTO8XSwTOmsgJFj62SEJCn512SvJyjRHASEi24g9b9XuysPe6blwbPQWAnlj5LgJEMHCBbJ0I Lk0cAhhLLlopVM1H/bFYunAw3sIAJG1dWM4V66g9LBzPUIE/aNTCPvhBWt158GDO/8WqtXxQW CZXfmRvKZFpDXn2QFQGuum2MRN0cBCvm+a6P/sxVdgSN3l+lIiUBMUez4TrnTs+NqRrhPinPl 74LLIY4E4yzLHmQ4Ye6jHrJhoCkVG6j33ZOis51qYqg3cE6AVg+EhzpA/ivgRVPjisFzQKKFe hizJScqw0ZeM2U4YWbopqrM9rOvM6RRmQUjzvUf1rIZFRLrZ7DKX6orKUE6PnmpVS7ZbsSEh6 ZEqohg== Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Dear all, just to confirm my understanding: Is it correct to say that the following sequence will "fix" all current collation version issues in a given database ? REINDEX DATABASE db_in_question; ALTER DATABASE db_in_question REFRESH COLLATION VERSION; ALTER COLLATION every_collation_from_pg_collation REFRESH VERSION; Note that I am currently _not_ concerned with minimizing work by running this on objects only that really need a reindex/refresh. Thanks, Karsten =2D- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B