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 1wAtgI-000Xxd-0U for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Apr 2026 18:00:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wAtgG-00703r-1N for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Apr 2026 18:00:41 +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 1wAtgG-00703j-0V for pgsql-hackers@lists.postgresql.org; Thu, 09 Apr 2026 18:00:41 +0000 Received: from mail-dy1-x132f.google.com ([2607:f8b0:4864:20::132f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wAtgE-00000000CaY-4ANu for pgsql-hackers@lists.postgresql.org; Thu, 09 Apr 2026 18:00:40 +0000 Received: by mail-dy1-x132f.google.com with SMTP id 5a478bee46e88-2c7d8bbad06so1881840eec.1 for ; Thu, 09 Apr 2026 11:00:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1775757638; x=1776362438; darn=lists.postgresql.org; h=subject:to:from:message-id:date:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=eYz4v+8HC3+Hv7byvQaaqlz6qw89k0Wd19SBs/+DUtg=; b=ksl4YcZbROzGLNPVwrfh5quMNwC7gPJhL0fOkibFcG7GN8BouFB5dNZvD+sQdLuP4D D4d1tldU4kAHdaC1R9npvkHQbgqiNEMP3dhdbXMP2FI5KiAc9Np2tNEIZtV/PyT6VQJL 4IqoH+lESr1dG2AEw9oMqqxj1IW9rdj+yYUbtNcow5ZLVDTsmelZ4Ai14ismvsBugEOD eQFvGhUDyoVXvgRhEhF7Fw5MHbZMcwYkwSSd9QzIzSTdI418aehxFRzlQhb1LX+l3pVp XOS3W5WzGsrPrG8rGafscCghHWIiM+ca0lj4plkYYBL2eWDUHovkZB/agDW1ih+jcpK5 0AHQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775757638; x=1776362438; h=subject:to:from:message-id:date:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=eYz4v+8HC3+Hv7byvQaaqlz6qw89k0Wd19SBs/+DUtg=; b=CQd6gI1r9NU7Mi16cy7GWJo+eHPAwwrR+NRpBspPfHWLfoVaSdilBl+Pbj7hQCCy7I pDcSRwFMWs2dk0dE9pe25FZL+PosxBhYFFKmd//YM8/23IPorWYvR/BBPOm2MNYeHQjQ wy+UkYJWA12yHc5VqPi7ieYCWxxbiBN9qvTnKvamJrDuPFObo+X7kLGaxOM7QoXvTMUU w05Z0hFZEZoOIe61ZzuTEh6oLS9rZvYM9xYK98ZLMOZ0+acEl1yeanfItYtG1+KZEm9Y kmGJr1iSefo/W8Kq3vG1FKKj1BAvaxiY+EPmWfsjQuuxAaWXMArESbwH6LCzOaY6is2h rnSg== X-Gm-Message-State: AOJu0YxIx/OY7qUmvqowbzF+mcw3bICNsQxAgwXOGDBa5zsLqeUyLGJZ qZAYTWNz7Mt3bWEy1uf+hXcIc9KoUOPtNpijOtH9l/jn3QWULGhytUa8fbNtDQ== X-Gm-Gg: AeBDiesgQWo/rI0Mly+aEwZvhk/ezznhymOlR86Pk5PuuV10m/uBCFexrGVAGCc1zoa fM7ehQeqrlO8kQ88u93PWkLV4IVDLKGtOvLWENt/9fC6cdVG4nsFMloI5oOITgXCY8yfVBW+OPf MbS1ORxrYRcHf2Zge9Xio9WOllDGj1CKNGAMheMCZ+DfErVshXQGDy2K+qaRTFrLiz4SxPw+Ozp Nh5ycpEghNidCg35MGcq3Pyddk6j6iY7Db7dL5G/4lmwCs/3SNh5ad7ckqnDp6MZ4E1AAooC6Hv F6+rqeWtittkHGWQMZ6LLMLhKRbDuFsne1rVdFJXwSBYW9Rx5hKsevR1EX9lxOofuqZL4gemcyC iBFOHbVeHgNU8/WH71wIAuTGeM8wJ4Ij0FuRBlJXXr9OAoqbga4ynsxEpWFbK3992O1uWyggmN/ CFiXx1SChuvKUjNiDG8TLeOBkXseBhAYUNsxCY5YAbYHuz+lHH/gdZxohr X-Received: by 2002:a05:7300:3246:b0:2c6:1557:998f with SMTP id 5a478bee46e88-2d589fa5006mr15731eec.25.1775757638171; Thu, 09 Apr 2026 11:00:38 -0700 (PDT) Received: from localhost ([2804:14d:328a:a59c:d80b:a5d1:ff0c:b61c]) by smtp.gmail.com with ESMTPSA id 5a478bee46e88-2d561cd3138sm645484eec.14.2026.04.09.11.00.36 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 09 Apr 2026 11:00:37 -0700 (PDT) Content-Type: multipart/mixed; boundary=7311e45532a664522bae11004c294894bc9a66736304f6e8f577bf29bfb8 Mime-Version: 1.0 Date: Thu, 09 Apr 2026 15:00:34 -0300 Message-Id: From: "Matheus Alcantara" To: Subject: docs: Include database collation check on SQL from alter_collation.sgml X-Mailer: aerc 0.21.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --7311e45532a664522bae11004c294894bc9a66736304f6e8f577bf29bfb8 Content-Type: multipart/alternative; boundary=a70bb1a7244f3ef986357e284de1945565724e41e90b2ff9781bca1280ca --a70bb1a7244f3ef986357e284de1945565724e41e90b2ff9781bca1280ca Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Content-Type: text/plain; charset=UTF-8 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. -- Matheus Alcantara EDB: https://www.enterprisedb.com --a70bb1a7244f3ef986357e284de1945565724e41e90b2ff9781bca1280ca-- --7311e45532a664522bae11004c294894bc9a66736304f6e8f577bf29bfb8 Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename=v1-0001-docs-Include-database-collation-check-on-SQL-from.patch Content-Type: text/plain; charset=utf-8; name=v1-0001-docs-Include-database-collation-check-on-SQL-from.patch RnJvbSBlNDQ2NzRkZmFlZTI3YmM0NDllMGYzZGU2NWEwOTI1ODUxYTU5OGEzIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBNYXRoZXVzIEFsY2FudGFyYSA8bXRocy5kZXZAcG0ubWU+CkRh dGU6IFRodSwgOSBBcHIgMjAyNiAxNDowOTowNSAtMDMwMApTdWJqZWN0OiBbUEFUQ0ggdjEgMS8y XSBkb2NzOiBJbmNsdWRlIGRhdGFiYXNlIGNvbGxhdGlvbiBjaGVjayBvbiBTUUwgZnJvbQogQUxU RVIgQ09MTEFUSU9OCgpQcmV2aW91c2x5IHRoZSBhbHRlcl9jb2xsYXRpb24uc2dtbCBkb2N1bWVu dGF0aW9uIHNlY3Rpb24gaW5jbHVkZSBhIFNRTAp0aGF0IGNhbiBiZSB1c2VkIHRvIGlkZW50aXR5 IGFsbCBjb2xsYXRpb25zIGluIHRoZSBjdXJyZW50IGRhdGFiYXNlIHRoYXQKbmVlZCB0byBiZSBy ZWZyZXNoZWQgZHVlIHRvIGEgY29sbGF0aW9uIHZlcnNpb24gbWlzcyBtYXRjaCBhbmQgdGhlCm9i amVjdHMgdGhhdCBkZXBlbmQgb24gdGhlbS4gSG93ZXZlciBpZiB0aGVyZSBpcyBvYmplY3RzIHRo YXQgdXNlIHRoZQpkYXRhYmFzZSBjb2xsYXRpb24gdGhlc2Ugb2JqZWN0cyBhcmUgbm90IHJldHVy bmVkIGJ5IHRoZSBxdWVyeS4KClRoaXMgY29tbWl0IGltcHJvdmUgdGhlIHF1ZXJ5IG9uIGFsdGVy X2NvbGxhdGlvbi5zZ21sIHRvIGluY2x1ZGUgdGhlCmRhdGFiYXNlIGNvbGxhdGlvbiB2ZXJzaW9u IGNoZWNrIHRvbyB0byByZXBvcnQgc3VjaCBjYXNlcy4KLS0tCiBkb2Mvc3JjL3NnbWwvcmVmL2Fs dGVyX2NvbGxhdGlvbi5zZ21sIHwgOCArKysrKysrLQogMSBmaWxlIGNoYW5nZWQsIDcgaW5zZXJ0 aW9ucygrKSwgMSBkZWxldGlvbigtKQoKZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9yZWYvYWx0 ZXJfY29sbGF0aW9uLnNnbWwgYi9kb2Mvc3JjL3NnbWwvcmVmL2FsdGVyX2NvbGxhdGlvbi5zZ21s CmluZGV4IGE0MGEzMTQ0MmE4Li5mMGMzYWYyMGI5NSAxMDA2NDQKLS0tIGEvZG9jL3NyYy9zZ21s L3JlZi9hbHRlcl9jb2xsYXRpb24uc2dtbAorKysgYi9kb2Mvc3JjL3NnbWwvcmVmL2FsdGVyX2Nv bGxhdGlvbi5zZ21sCkBAIC0xNjQsNyArMTY0LDEzIEBAIFNFTEVDVCBwZ19kZXNjcmliZV9vYmpl Y3QocmVmY2xhc3NpZCwgcmVmb2JqaWQsIHJlZm9ianN1YmlkKSBBUyAiQ29sbGF0aW9uIiwKICAg ICAgICBwZ19kZXNjcmliZV9vYmplY3QoY2xhc3NpZCwgb2JqaWQsIG9ianN1YmlkKSBBUyAiT2Jq ZWN0IgogICBGUk9NIHBnX2RlcGVuZCBkIEpPSU4gcGdfY29sbGF0aW9uIGMKICAgICAgICBPTiBy ZWZjbGFzc2lkID0gJ3BnX2NvbGxhdGlvbic6OnJlZ2NsYXNzIEFORCByZWZvYmppZCA9IGMub2lk Ci0gIFdIRVJFIGMuY29sbHZlcnNpb24gPD4gcGdfY29sbGF0aW9uX2FjdHVhbF92ZXJzaW9uKGMu b2lkKQorICAgICAgIEpPSU4gcGdfZGF0YWJhc2UgZGIgT04gZGIuZGF0bmFtZSA9IGN1cnJlbnRf ZGF0YWJhc2UoKQorICBXSEVSRSBjLmNvbGxwcm92aWRlciBJTiAoJ2QnLCAnYycpCisgICAgQU5E ICgKKyAgICAgICAgKGMuY29sbHByb3ZpZGVyID0gJ2QnIEFORCBkYi5kYXRjb2xsdmVyc2lvbiA8 PiBwZ19kYXRhYmFzZV9jb2xsYXRpb25fYWN0dWFsX3ZlcnNpb24oZGIub2lkKSkKKyAgICAgICAg T1IKKyAgICAgICAgKGMuY29sbHByb3ZpZGVyID0gJ2MnIEFORCBjLmNvbGx2ZXJzaW9uIDw+IHBn X2NvbGxhdGlvbl9hY3R1YWxfdmVyc2lvbihjLm9pZCkpCisgICAgKQogICBPUkRFUiBCWSAxLCAy OwogXV0+PC9wcm9ncmFtbGlzdGluZz48L3BhcmE+CiAgPC9yZWZzZWN0MT4KLS0gCjIuNTMuMAoK --7311e45532a664522bae11004c294894bc9a66736304f6e8f577bf29bfb8--