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
