Re: [BUGS] "SET search_path" clause ignored during function creation - Mailing list pgsql-hackers

From Takahiro Itagaki
Subject Re: [BUGS] "SET search_path" clause ignored during function creation
Date
Msg-id 20100510153419.9C58.52131E4D@oss.ntt.co.jp
Whole thread Raw
Responses Re: [BUGS] "SET search_path" clause ignored during function creation  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: max_standby_delay considered harmful
Next
From: Dimitri Fontaine
Date:
Subject: Re: max_standby_delay considered harmful