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
From:
gordo169@gmail.com Date: Subject:
BUG #9505: If a function references an unqualified table,
it only resolves it from search_path once per session