Re: security_definer_search_path GUC

[Joel Jacobson]

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.
/Joel