Re: Prepared statement not using an index

On 02.09.2005, at 0:52 Uhr, Oliver Jowett wrote:

>> I use PostgreSQL 8.0.3 on Mac OS X and the JDBC driver 8.0-312
>> JDBC 3.
>>
>> After a lot of other things, I tried using a 7.4 driver and with
>> this,
>> the index is used in both cases.
>>
>
> The 8.0 drivers pass parameters individually to the backend (analogous
> to using PREPARE/EXECUTE), while the 7.4 drivers do textual
> substitution
> into the query text. This can result in different query plans as
> you've
> discovered.

This sounds like a bug to me. If a simple substitution of the
placeholders with actual values ends with different query plan, my
understanding is, that there is something broken in the query
planner ...

cug