Oliver Jowett <[EMAIL PROTECTED]> writes:
> Simon Riggs wrote:
>> OK, thats what I hoped you'd say. With a prepared query all of the
>> statements execute the same plan, so you don't need to know the exact
>> parameters.

> This isn't true in 8.0 if you are using the unnamed statement (as the
> JDBC driver does in some cases): the plan chosen depends on the
> parameter values given in the first Bind.

Also, "what plan got chosen" isn't the only question that a DBA might
want the log to answer.  "Where did my data get screwed up" is at least
as likely an application.

I'm a bit worried about the costs of converting binary-format parameters
into text form ...

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to