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.

Reply via email to