| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | PFC <lists(at)peufeu(dot)com> |
| Cc: | Csaba Nagy <nagy(at)ecircle-ag(dot)com>, Dawid Kuroczko <qnex42(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Cached Query Plans (was: global prepared statements) |
| Date: | 2008-04-14 13:36:58 |
| Message-ID: | 200804141336.m3EDaw000551@momjian.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
PFC wrote:
> Bind message behaviour was modified :
> - If the user asks for execution of a named prepared statement, and the
> named statement does not exist in PG's prepared statements cache, instead
> of issuing an error and borking the transaction, it Binds to an empty
> statement, that takes no parameters, and returns no result. Parameters
> sent by the user are consumed but not used.
You mentioned the need for a wire protocol change to allow this. Why
can't this be controlled with a server variable, like SET auto_prepare =
'true'?
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2008-04-14 13:54:10 | Re: Cached Query Plans (was: global prepared statements) |
| Previous Message | Ron Mayer | 2008-04-14 13:15:43 | Re: Index AM change proposals, redux |