| From: | "Matheus Alcantara" <matheusssilv97(at)gmail(dot)com> |
|---|---|
| To: | <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | docs: Include database collation check on SQL from alter_collation.sgml |
| Date: | 2026-04-09 18:00:34 |
| Message-ID: | DHOTJNEQ82FK.2VR8AIQNLO6UP@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| Attachment | Content-Type | Size |
|---|---|---|
| v1-0001-docs-Include-database-collation-check-on-SQL-from.patch | text/plain | 1.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sami Imseih | 2026-04-09 18:02:37 | Allow a condition string in an injection point |
| Previous Message | Alexander Lakhin | 2026-04-09 18:00:00 | Re: test_autovacuum/001_parallel_autovacuum is broken |