Request a Demo
Home   >   mailing lists

docs: Include database collation check on SQL from alter_collation.sgml - Mailing list pgsql-hackers

From Matheus Alcantara
Subject docs: Include database collation check on SQL from alter_collation.sgml
Date
Msg-id DHOTJNEQ82FK.2VR8AIQNLO6UP@gmail.com
Whole thread Raw
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Alexander Lakhin
Date:
Subject: Re: test_autovacuum/001_parallel_autovacuum is broken
Next
From: Sami Imseih
Date:
Subject: Allow a condition string in an injection point