Re: replanning Prepared Statements ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Sahagian, David" <david(dot)sahagian(at)emc(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: replanning Prepared Statements ?
Date: 2013-05-13 18:39:17
Message-ID: 8528.1368470357@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Sahagian, David" <david(dot)sahagian(at)emc(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bret Stern 2013-05-13 20:23:31 Update from select
Previous Message Naveed Shaikh 2013-05-13 18:26:49 Re: replanning Prepared Statements ?