Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Bug? Prepared queries continue to use search_path from their preparation time
Date
Msg-id 23893.1342015635@sss.pgh.pa.us
Whole thread Raw
In response to Bug? Prepared queries continue to use search_path from their preparation time  (Toby Corkindale <toby.corkindale@strategicdata.com.au>)
Responses Re: Bug? Prepared queries continue to use search_path from their preparation time  (Toby Corkindale <toby.corkindale@strategicdata.com.au>)
List pgsql-general
Tree view 
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.

            regards, tom lane

pgsql-general by date:

Previous
From: Jeff Ross
Date:
Subject: Re: Transaction question
Next
From: Jerry Sievers
Date:
Subject: Re: Bug? Prepared queries continue to use search_path from their preparation time