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 1wCOWY-001wC6-1t for pgsql-hackers@arkaria.postgresql.org; Mon, 13 Apr 2026 21:08:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wCOWX-008l6z-02 for pgsql-hackers@arkaria.postgresql.org; Mon, 13 Apr 2026 21:08:49 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wCOWW-008l6r-2G for pgsql-hackers@lists.postgresql.org; Mon, 13 Apr 2026 21:08:49 +0000 Received: from mail-dl1-x1231.google.com ([2607:f8b0:4864:20::1231]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wCOWV-00000000uXX-0PMo for pgsql-hackers@lists.postgresql.org; Mon, 13 Apr 2026 21:08:49 +0000 Received: by mail-dl1-x1231.google.com with SMTP id a92af1059eb24-12c287eb77fso5934457c88.1 for ; Mon, 13 Apr 2026 14:08:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1776114525; x=1776719325; darn=lists.postgresql.org; h=in-reply-to:references:to:from:subject:message-id:date:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=+VIp1O8UhDjOcL9sGmXP/JENtjS0AOkt8IfoC6IUdSE=; b=DCFK/WeRZrfZNrBrfjOcjTYfOrn6qPyRLNdAH1hZq03KbSevQXwas4wxfDRxkDqv74 4uUH6DF14E82/XnpJSRGZF/oqFtAFhPMEFXoSir+kwURez+TQIoqfKJDdFiuUKSwArhm m2Im8ilvVvliCuH1rALGPo+mynZz6u5pFcv9p4m90wHJ6ec702GJ+Rzqr0OUNPl4ZNoh gQNGDZkhcWDJTlH3SxbCB8bktT0SEk8a56DdfAmeKMj0E0d0ukIg3kjQV+vJAlkqu0cJ WbEQMk4QXGcVM/cFxq3fHJYHId+t/sqFmJEAbh5qaTLomFLoUGhblmATMagtvkezn6xv CxLw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1776114525; x=1776719325; h=in-reply-to:references:to:from:subject:message-id:date:mime-version :x-gm-gg:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=+VIp1O8UhDjOcL9sGmXP/JENtjS0AOkt8IfoC6IUdSE=; b=DTJkg2x0teD0qpnn6iNT0ixoYQS+ah2x5v/M+wJ8ymR9Ly/WrZWunn3wrXkZtxRVFa yfrZJKgNdgREG/T4xP4xs2i/kKgYQN0G+OkQ3O1fhFqw6BqBXl//YzoabLPnpVqjVaMg T+5Kcu2EypeFqSA0WlymPsp9mbGfbC80M3j17dNNBM3NBH2vzXAgZdMZRC96/nZJAovE ldndOQkECatvKqESMlF2lUu8JocWBh9hp6r9bT+laSOJfGwxFvTX4v0fkxIq5pKwQdgd aL8sU30lWlwJcZZMe3HCy1kPohDhgVLiaTtO9XIa6ogX6fHVuA/gZqVjQtrgRLmuFXkK doxQ== X-Gm-Message-State: AOJu0YzaTHLpmDLi1OalMKlgB5O5Yj4NrUn2NHP+NG5jQbF4tWcMb0aS jS4AIDyvAAZ+gTLV03uax/qlNjFQopNGV2ZxBg+KygEP4+UEjsDRvrh/laplYA== X-Gm-Gg: AeBDiev6pMULPwReeygapY2YXbl1vs9koAcvxsZScmEt9V2O7+Y/9N58ef1G3Fd43u3 keBi/UYst6+0qJFHIE6twtcaUqrKukACfL/I+gvbz6CHsjAf4jUGyFLA/fW0IaS170obo7CxvSl EkM71empgwvYSk5/baUIqfccI2xXGsjy6DHHfSAJw526XmAp4omznBkyDIhaHKHMkcqPQcb0Jnn MG2AhV6mQWzuCKxDswyJYc6skLrQiw2ezLNd2mciPyAe8Y2wwBr+x3PWcBItUL2GaToezHjpG0e jnH0TRe/z9qfUDC1U5raSYAMhHMrNXtij7W8N/JWfEuI9N5qAnxCAJBP3rkDMfR0tWuHDYr4Xb6 wkQD0vMogvZWpUSav3UipeyGU6oMwdH3KG76TjEvQZDPChLjp8oSBWCChszR8bNs1AB5rEe5Eg2 WMYdtj6t5ztKjLIo0Auxu4j+5oImjH/1uya0lncd0uyaRFDA== X-Received: by 2002:a05:7022:fa8:b0:128:d2a5:709c with SMTP id a92af1059eb24-12c34f18363mr8486368c88.33.1776114524029; Mon, 13 Apr 2026 14:08:44 -0700 (PDT) Received: from localhost ([2804:14d:328a:a59c:556f:88fe:b643:c0f9]) by smtp.gmail.com with ESMTPSA id a92af1059eb24-12c346eb314sm15114980c88.10.2026.04.13.14.08.42 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 13 Apr 2026 14:08:43 -0700 (PDT) Content-Type: multipart/mixed; boundary=668380653672622f00ce7b630ec5e76f5582617e9585bde0365ad77779f9 Mime-Version: 1.0 Date: Mon, 13 Apr 2026 18:08:40 -0300 Message-Id: Subject: Re: docs: Include database collation check on SQL from alter_collation.sgml From: "Matheus Alcantara" To: X-Mailer: aerc 0.21.0 References: In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --668380653672622f00ce7b630ec5e76f5582617e9585bde0365ad77779f9 Content-Type: multipart/alternative; boundary=f80d806970b4acd85a8fac3de9efb193e5ea6223620d2fbb7045d696771d --f80d806970b4acd85a8fac3de9efb193e5ea6223620d2fbb7045d696771d Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Content-Type: text/plain; charset=UTF-8 On Thu Apr 9, 2026 at 3:00 PM -03, Matheus Alcantara wrote: > Hi, > > The ALTER COLLATION documentation section include a SQL that can be used > to identity all collations in the current database that need to be > refreshed due to a collation version miss match and the objects that > depend on them. However if there is objects that use the database > collation these objects are not returned by the query. > > The attached patch change the query to include the database collation > check to report collation version miss match for objects that use the > database default collation as they are not stored on pg_depend. > The proposed SQL on the v1 patch still don't handle the cases where an index is using the database default collation.=20 The new v2 attached handle it properly. The new query is based on the query suggested on Locale data changes wiki page [1] but with some changes to check the collation version mismatch. [1] https://wiki.postgresql.org/wiki/Locale_data_changes -- Matheus Alcantara EDB: https://www.enterprisedb.com --f80d806970b4acd85a8fac3de9efb193e5ea6223620d2fbb7045d696771d-- --668380653672622f00ce7b630ec5e76f5582617e9585bde0365ad77779f9 Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename=v2-0001-docs-Include-database-collation-check-on-SQL-from.patch Content-Type: text/plain; charset=utf-8; name=v2-0001-docs-Include-database-collation-check-on-SQL-from.patch RnJvbSBkN2ZlYzFjZjcxNGQ3Njg4YjI1NmVkY2RiZDNhNjgzZDkyM2E2NDY1IE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBNYXRoZXVzIEFsY2FudGFyYSA8bXRocy5kZXZAcG0ubWU+CkRh dGU6IFRodSwgOSBBcHIgMjAyNiAxNDowOTowNSAtMDMwMApTdWJqZWN0OiBbUEFUQ0ggdjJdIGRv Y3M6IEluY2x1ZGUgZGF0YWJhc2UgY29sbGF0aW9uIGNoZWNrIG9uIFNRTCBmcm9tIEFMVEVSCiBD T0xMQVRJT04KClByZXZpb3VzbHkgdGhlIGFsdGVyX2NvbGxhdGlvbi5zZ21sIGRvY3VtZW50YXRp b24gc2VjdGlvbiBpbmNsdWRlIGEgU1FMCnRoYXQgY2FuIGJlIHVzZWQgdG8gaWRlbnRpdHkgYWxs IGNvbGxhdGlvbnMgaW4gdGhlIGN1cnJlbnQgZGF0YWJhc2UgdGhhdApuZWVkIHRvIGJlIHJlZnJl c2hlZCBkdWUgdG8gYSBjb2xsYXRpb24gdmVyc2lvbiBtaXNzIG1hdGNoIGFuZCB0aGUKb2JqZWN0 cyB0aGF0IGRlcGVuZCBvbiB0aGVtLiBIb3dldmVyIGlmIHRoZXJlIGlzIG9iamVjdHMgdGhhdCB1 c2UgdGhlCmRhdGFiYXNlIGNvbGxhdGlvbiB0aGVzZSBvYmplY3RzIGFyZSBub3QgcmV0dXJuZWQg YnkgdGhlIHF1ZXJ5LgoKVGhpcyBjb21taXQgaW1wcm92ZSB0aGUgcXVlcnkgb24gYWx0ZXJfY29s bGF0aW9uLnNnbWwgdG8gaW5jbHVkZSB0aGUKZGF0YWJhc2UgY29sbGF0aW9uIHZlcnNpb24gY2hl Y2sgdG9vIHRvIHJlcG9ydCBzdWNoIGNhc2VzLgotLS0KIGRvYy9zcmMvc2dtbC9yZWYvYWx0ZXJf Y29sbGF0aW9uLnNnbWwgfCAyNiArKysrKysrKysrKysrKysrKysrKy0tLS0tLQogMSBmaWxlIGNo YW5nZWQsIDIwIGluc2VydGlvbnMoKyksIDYgZGVsZXRpb25zKC0pCgpkaWZmIC0tZ2l0IGEvZG9j L3NyYy9zZ21sL3JlZi9hbHRlcl9jb2xsYXRpb24uc2dtbCBiL2RvYy9zcmMvc2dtbC9yZWYvYWx0 ZXJfY29sbGF0aW9uLnNnbWwKaW5kZXggYTQwYTMxNDQyYTguLjZjNDBkMWZiMjZmIDEwMDY0NAot LS0gYS9kb2Mvc3JjL3NnbWwvcmVmL2FsdGVyX2NvbGxhdGlvbi5zZ21sCisrKyBiL2RvYy9zcmMv c2dtbC9yZWYvYWx0ZXJfY29sbGF0aW9uLnNnbWwKQEAgLTE2MCwxMiArMTYwLDI2IEBAIEhJTlQ6 ICBSZWJ1aWxkIGFsbCBvYmplY3RzIGFmZmVjdGVkIGJ5IHRoaXMgY29sbGF0aW9uIGFuZCBydW4g QUxURVIgQ09MTEFUSU9OIHBnCiAgICBUaGUgZm9sbG93aW5nIHF1ZXJ5IGNhbiBiZSB1c2VkIHRv IGlkZW50aWZ5IGFsbCBjb2xsYXRpb25zIGluIHRoZSBjdXJyZW50CiAgICBkYXRhYmFzZSB0aGF0 IG5lZWQgdG8gYmUgcmVmcmVzaGVkIGFuZCB0aGUgb2JqZWN0cyB0aGF0IGRlcGVuZCBvbiB0aGVt OgogPHByb2dyYW1saXN0aW5nPjwhW0NEQVRBWwotU0VMRUNUIHBnX2Rlc2NyaWJlX29iamVjdChy ZWZjbGFzc2lkLCByZWZvYmppZCwgcmVmb2Jqc3ViaWQpIEFTICJDb2xsYXRpb24iLAotICAgICAg IHBnX2Rlc2NyaWJlX29iamVjdChjbGFzc2lkLCBvYmppZCwgb2Jqc3ViaWQpIEFTICJPYmplY3Qi Ci0gIEZST00gcGdfZGVwZW5kIGQgSk9JTiBwZ19jb2xsYXRpb24gYwotICAgICAgIE9OIHJlZmNs YXNzaWQgPSAncGdfY29sbGF0aW9uJzo6cmVnY2xhc3MgQU5EIHJlZm9iamlkID0gYy5vaWQKLSAg V0hFUkUgYy5jb2xsdmVyc2lvbiA8PiBwZ19jb2xsYXRpb25fYWN0dWFsX3ZlcnNpb24oYy5vaWQp Ci0gIE9SREVSIEJZIDEsIDI7CitTRUxFQ1QgRElTVElOQ1QKKyAgY3VycmVudGRiIEFTIGRhdGFi YXNlLAorICBpbmRyZWxpZDo6cmVnY2xhc3M6OnRleHQgQVMgdGFibGUsCisgIGluZGV4cmVsaWQ6 OnJlZ2NsYXNzOjp0ZXh0IEFTIGluZGV4LAorICBjb2xsbmFtZSwKKyAgY29sbHByb3ZpZGVyLAor ICBDQVNFIFdIRU4gY29sbHByb3ZpZGVyPSdkJyBUSEVOIGRhdGNvbGx2ZXJzaW9uIEVMU0UgY29s bHZlcnNpb24gRU5EIEFTIGNvbGxhdGlvbl92ZXJzaW9uLAorICBDQVNFIFdIRU4gY29sbHByb3Zp ZGVyPSdkJyBUSEVOIHBnX2RhdGFiYXNlX2NvbGxhdGlvbl9hY3R1YWxfdmVyc2lvbihkLm9pZCkg RUxTRSBwZ19jb2xsYXRpb25fYWN0dWFsX3ZlcnNpb24oYy5vaWQpIEVORCBBUyBhY3R1YWxfY29s bGF0aW9uX3ZlcnNpb24sCisgIHBnX2dldF9pbmRleGRlZihpbmRleHJlbGlkKSBBUyBpbmRleF9k ZWZpbml0aW9uCitGUk9NCisgIChTRUxFQ1QgaW5kZXhyZWxpZCwgaW5kcmVsaWQsIGluZGNvbGxh dGlvbltpXSBjb2xsLCBjdXJyZW50X2RhdGFiYXNlKCkgQVMgY3VycmVudGRiIEZST00gcGdfaW5k ZXgsIGdlbmVyYXRlX3N1YnNjcmlwdHMoaW5kY29sbGF0aW9uLCAxKSBnKGkpKSBzCisgICAgICBK T0lOIHBnX2NvbGxhdGlvbiBjIE9OIGNvbGw9Yy5vaWQKKyAgICBKT0lOIHBnX2RhdGFiYXNlIGQg T04gY3VycmVudGRiPWQuZGF0bmFtZQorV0hFUkUKKyAgKAorICAgICgoY29sbHByb3ZpZGVyPSdk JykgQU5EIChkLmRhdGxvY3Byb3ZpZGVyPSdjJykgQU5EIGQuZGF0Y29sbHZlcnNpb24gPD4gcGdf ZGF0YWJhc2VfY29sbGF0aW9uX2FjdHVhbF92ZXJzaW9uKGQub2lkKSkKKyAgT1IKKyAgICAoKGNv bGxwcm92aWRlcj0nYycpIEFORCBjb2xsdmVyc2lvbiA8PiBwZ19jb2xsYXRpb25fYWN0dWFsX3Zl cnNpb24oYy5vaWQpICkKKyAgKSBBTkQKKyAgY29sbG5hbWUgTk9UIElOICgnQycsICdQT1NJWCcp OwogXV0+PC9wcm9ncmFtbGlzdGluZz48L3BhcmE+CiAgPC9yZWZzZWN0MT4KIAotLSAKMi41My4w Cgo= --668380653672622f00ce7b630ec5e76f5582617e9585bde0365ad77779f9--