Re: Prepared Statement Question - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Prepared Statement Question
Date
Msg-id 2677.1160410106@sss.pgh.pa.us
Whole thread Raw
In response to Prepared Statement Question  ("Strong, David" <david.strong@unisys.com>)
List pgsql-hackers
"Strong, David" <david.strong@unisys.com> writes:
> There is similar code for Parameter Lists (ParamListInfo) and Result Format Codes (rformats). Unless we're missing
something,a prepared statement would probably never change once prepared. 
 

I think you're missing something.  Or are you just proposing that we
could save one palloc per Bind operation?  Trust me, that ain't worth
worrying about.  In any case the number of parameters appearing in Bind
could be different from the number appearing in the statement --- the
fact that that's an error doesn't allow you to not process the message
before complaining.

> Along these lines, would it also be possible to keep an Executor State and Expression Context with the statement and
justreset key parts of them, rather than rebuilding them from scratch each time a prepared statement is executed?
 

Sounds highly bug-prone to me ... especially in the case where the
preceding execution didn't complete normally ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Upgrading a database dump/restore
Next
From: "Strong, David"
Date:
Subject: Re: Prepared Statement Question