Re: Another thought about search_path semantics

On 04/04/2014 01:47 PM, Andres Freund wrote:
> I wonder if we could extend the search path syntax to specify whether a
> schema should be used for creation of objects or not. Sounds somewhat
> nasty, but I don't really have a better idea :(. Something like
> search_patch=public,!pg_catalog.

No, if we're fixing this, then we should have a separate
"creation_target_schema" GUC.   The fact that the only way to designate
creation target schema was to put it at the start of the search path has
*always* been a problem, since 7.3.

Non-atomic data sucks.  ;-b

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com