Ernst Bachmann wrote:
> The following bug has been logged online:
>
> Bug reference: 1753
> Logged by: Ernst Bachmann
> Email address: [EMAIL PROTECTED]
> PostgreSQL version: 8.0.3
> Operating system: Linux
> Description: Query Optimizer does not work well with libpg /
> PQexecParams
> Details:
>
> It looks like the query optimizer isn't taking the value of parameters sent
> with PQexecParams into account, thus generating (in my case, very) unoptimal
> plans
If PQexecParams uses the unnamed statement (it appears to), this
shouldn't happen -- planning of the unnamed statement is delayed until
the first set of parameter values is bound. This behaviour started in 8.0.
What's the query?
Are you definitely using PQexecParams() and not PQexecPrepared()?
-O
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
