pá 4. 6. 2021 v 17:43 odesílatel Joel Jacobson <joel@compiler.org> napsal:
Maybe this could work: CREATE SCHEMA schema_name UNQUALIFIED; Which would explicitly make all the objects created in the schema accessible unqualified, but also enforce there are no conflicts with other objects in existence in all unqualified schemas, upon the creation of new objects.
Yes, it can work. I am not sure if "unqualified" is the best keyword, but the idea is workable.
Sounds like a job for an event trigger listening to CREATE/ALTER schema.