Re: Another thought about search_path semantics

On 2014-04-04 14:56:54 -0400, Tom Lane wrote:
> Andres Freund <andres@2ndquadrant.com> writes:
> > I was actually suggesting that the only way to create something in
> > pg_catalog is to do it with a explicit schema qualified id. I realize
> > that that's not something backpatchable...
> 
> I don't find that to be a good idea at all.  pg_dump is probably not the
> only code that believes it can select a creation target with search_path,
> no matter what that target is.

Sure, but how many of those are trying to put things in pg_catalog?

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services