Postgres Pro
Downloads
Home   >   mailing lists

Thread: replanning Prepared Statements ?

replanning Prepared Statements ?

From
"Sahagian, David"
Date:

I see in the Release Notes for 9.3 beta . . .

 

  “Force cached functions to be replanned if the search_path changes (Tom Lane)

  Previously functions already run in the current session ignored search_path changes.”

 

Question:

  Do Prepared Statements also get replanned, if the search_path changes ?

 

Thanks,

-dvs-

Re: replanning Prepared Statements ?

From
Naveed Shaikh
Date:
Hi,

Please follow the below link for the release notes:


Hope this helps.


--
Thanks & Regards,
Naveed Shaikh



On Mon, May 13, 2013 at 11:53 PM, Sahagian, David <david.sahagian@emc.com> wrote:

I see in the Release Notes for 9.3 beta . . .

 

  “Force cached functions to be replanned if the search_path changes (Tom Lane)

  Previously functions already run in the current session ignored search_path changes.”

 

Question:

  Do Prepared Statements also get replanned, if the search_path changes ?

 

Thanks,

-dvs-


Re: replanning Prepared Statements ?

From
Tom Lane
Date:
"Sahagian, David" <david.sahagian@emc.com> writes:
> I see in the Release Notes for 9.3 beta . . .
>   "Force cached functions to be replanned if the search_path changes (Tom Lane)
>   Previously functions already run in the current session ignored search_path changes."

> Question:
>   Do Prepared Statements also get replanned, if the search_path changes ?

Yes ... that release note text still needs work, it's really about any
cached plan, which affects more than just functions.

            regards, tom lane

Re: replanning Prepared Statements ?

From
Bruce Momjian
Date:
On Mon, May 13, 2013 at 02:39:17PM -0400, Tom Lane wrote:
> "Sahagian, David" <david.sahagian@emc.com> writes:
> > I see in the Release Notes for 9.3 beta . . .
> >   "Force cached functions to be replanned if the search_path changes (Tom Lane)
> >   Previously functions already run in the current session ignored search_path changes."
>
> > Question:
> >   Do Prepared Statements also get replanned, if the search_path changes ?
>
> Yes ... that release note text still needs work, it's really about any
> cached plan, which affects more than just functions.

OK, attached release note patch applied.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +
Attachment