On 03/09/2014 10:45 PM, gordo169(at)gmail(dot)com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 9505
> Logged by: Gordon Shannon
> Email address: gordo169(at)gmail(dot)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