Re: "SET search_path" clause ignored during function creation - Mailing list pgsql-bugs

From Takahiro Itagaki
Subject Re: "SET search_path" clause ignored during function creation
Date
Msg-id 20100510153419.9C58.52131E4D@oss.ntt.co.jp
Whole thread Raw
In response to "SET search_path" clause ignored during function creation  (Erwin Brandstetter <brsaweda@gmail.com>)
Responses Re: "SET search_path" clause ignored during function creation
List pgsql-bugs
Erwin Brandstetter <brsaweda@gmail.com> 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
> search path at the time pof creation.

Thanks for the report!  Please check whether the attached patch
is the correct fix. An additional regression test is included.

Regards,
---
Takahiro Itagaki
NTT Open Source Software Center


Attachment

pgsql-bugs by date:

Previous
From: Takahiro Itagaki
Date:
Subject: Re: BUG #5450: system lacked sufficient buffer space, or because a queue was full, could not perform the operation
Next
From: Peter Eisentraut
Date:
Subject: Re: bool: symbol name collision