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