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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
