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

From: Vik Fearing <vik(dot)fearing(at)dalibo(dot)com>
To: gordo169(at)gmail(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #9505: If a function references an unqualified table, it only resolves it from search_path once per session
Date: 2014-03-09 21:57:20
Message-ID: 531CE3C0.3020801@dalibo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2014-03-09 23:47:15 Re: BUG #9485: RFE - cycling sequence rollover to do modulo
Previous Message gordo169 2014-03-09 21:45:04 BUG #9505: If a function references an unqualified table, it only resolves it from search_path once per session