Re: Cached Query Plans (was: global prepared statements) - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Cached Query Plans (was: global prepared statements)
Date
Msg-id 200804141336.m3EDaw000551@momjian.us
Whole thread Raw
In response to Re: Cached Query Plans (was: global prepared statements)  (PFC <lists@peufeu.com>)
Responses Re: Cached Query Plans (was: global prepared statements)  (PFC <lists@peufeu.com>)
List 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@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: Ron Mayer
Date:
Subject: Re: Index AM change proposals, redux
Next
From: Heikki Linnakangas
Date:
Subject: Re: Cached Query Plans (was: global prepared statements)