Re: BUG #9505: If a function references an unqualified table, it only resolves it from search_path once per session

On 03/09/2014 10:45 PM, gordo169@gmail.com wrote:
> The following bug has been logged on the website:
>
> Bug reference:      9505
> Logged by:          Gordon Shannon
> Email address:      gordo169@gmail.com
> PostgreSQL version: 9.2.4
> Operating system:   Centos
> Description:
>
> After session starts, 1st time you run a function with an unqualified
> schema, it will use search_path to resolve.  If in the same session you set
> search_path to point to a different schema with the same table name, when
> you rerun the function it still resolves to the original schema.


This was fixed in 9.3.

http://www.postgresql.org/docs/9.3/static/release-9-3.html#AEN114856
--
Vik