[HACKERS] Re: pg_dump does not honor namespaces when functions are used in index

2010-06-18 Thread Thom Brown
On 18 June 2010 09:31, Jean-Baptiste Quenot wrote: > 2010/6/17 Greg Stark : > > On Thu, Jun 17, 2010 at 4:08 PM, Tom Lane wrote: > >>> I actually wonder if we shouldn't automatically tag plpgsql functions > >>> with the search_path in effect at the time of their creation (as if > >>> the user ha

[HACKERS] Re: pg_dump does not honor namespaces when functions are used in index

2010-06-18 Thread Jean-Baptiste Quenot
2010/6/17 Greg Stark : > On Thu, Jun 17, 2010 at 4:08 PM, Tom Lane wrote: >>> I actually wonder if we shouldn't automatically tag plpgsql functions >>> with the search_path in effect at the time of their creation (as if >>> the user had done ALTER FUNCTION ... SET search_path=...whatever the >>> c

[HACKERS] Re: pg_dump does not honor namespaces when functions are used in index

2010-06-17 Thread Greg Stark
On Thu, Jun 17, 2010 at 4:08 PM, Tom Lane wrote: >> I actually wonder if we shouldn't automatically tag plpgsql functions >> with the search_path in effect at the time of their creation (as if >> the user had done ALTER FUNCTION ... SET search_path=...whatever the >> current search path is...). >