Re: [HACKERS] [BUGS] "SET search_path" clause ignored during function creation

2010-05-10 Thread Takahiro Itagaki
Tom Lane wrote: > Takahiro Itagaki writes: > > Thanks for the report! Please check whether the attached patch > > is the correct fix. An additional regression test is included. > > That's going to provoke "uninitialized variable" compiler warnings, > but otherwise it seems reasonably sane. I

Re: [BUGS] "SET search_path" clause ignored during function creation

2010-05-10 Thread Tom Lane
Takahiro Itagaki writes: > Thanks for the report! Please check whether the attached patch > is the correct fix. An additional regression test is included. That's going to provoke "uninitialized variable" compiler warnings, but otherwise it seems reasonably sane. I don't particularly see the poi

Re: [BUGS] "SET search_path" clause ignored during function creation

2010-05-09 Thread Takahiro Itagaki
Erwin Brandstetter wrote: > Function bodies are checked using the _current_ search_path instead of > the search_path supplied by the "SET search_path" clause. > > Proposed solution: Function bodies should be checked with the > search_path provided by "SET search_path" an _not_ with the current

[BUGS] "SET search_path" clause ignored during function creation

2010-05-06 Thread Erwin Brandstetter
As discussed in irc://freenode/postgresql (2010-05-06 16:20) Function bodies are checked using the _current_ search_path instead of the search_path supplied by the "SET search_path" clause. This leads to wrong error messages during creation. On the other hand it can make a function body pass the ch