Re: Bug? Prepared queries continue to use search_path from their preparation time - Mailing list pgsql-general

From Toby Corkindale
Subject Re: Bug? Prepared queries continue to use search_path from their preparation time
Date
Msg-id 4FFE25EA.3010707@strategicdata.com.au
Whole thread Raw
In response to Re: Bug? Prepared queries continue to use search_path from their preparation time  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Bug? Prepared queries continue to use search_path from their preparation time
List pgsql-general
On 12/07/12 00:07, Tom Lane wrote:
> Toby Corkindale <toby.corkindale@strategicdata.com.au> writes:
>> The issue occurs when you have server-side prepared queries enabled, and
>> then change the search_path parameter after creating a prepared query.
>> Future executions of that query still seem to be using the original
>> search_path.
>
> This behavior is intentional.

In that case, the error lies with the Perl libraries that automatically
prepare and cache queries, but do not include the search_path in the
cache keys.

I'll bring it up with them.

thanks for your advice,
Toby

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Sequence moves forward when failover is triggerred
Next
From: Craig Ringer
Date:
Subject: Re: PostgreSQL limitations question