On Fri, Jun 4, 2021 at 9:03 AM Pavel Stehule <pavel.steh...@gmail.com> wrote:
> pá 4. 6. 2021 v 17:43 odesílatel Joel Jacobson <j...@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. David J.