replanning Prepared Statements ?

Hi,

Please follow the below link for the release notes:

http://www.postgresql.org/docs/devel/static/release-9-3.html

Hope this helps.

--
Thanks & Regards,
Naveed Shaikh

On Mon, May 13, 2013 at 11:53 PM, Sahagian, David <david.sahagian@emc.com>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.

regards, tom lane

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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. +