On Wed, 2024-06-12 at 21:13 +0200, Karsten Hilbert wrote:
> > Note that with DROP COLLATION you can only remove collations
> > that belong to the encoding of your current database.
>
> A-ha ! Can that bit be found anywhere in the docs ?
src/backend/catalog/namespace.c:
/*
* get_collation_oid - find a collation by possibly qualified name
*
* Note that this will only find collations that work with the current
* database's encoding.
*/
Oid
get_collation_oid(List *collname, bool missing_ok)
Yours,
Laurenz Albe