Re: Upgrading JDBC driver from 7.3 to 8.4 affected execution plans - Mailing list pgsql-jdbc

From Boris Partensky
Subject Re: Upgrading JDBC driver from 7.3 to 8.4 affected execution plans
Date
Msg-id AANLkTi=hA5R+REbnsWpB9zYrfyd6cbGL5vQgpCHJnkg-@mail.gmail.com
Whole thread Raw
In response to Re: Upgrading JDBC driver from 7.3 to 8.4 affected execution plans  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
Oliver, yes. I agree with you, I am still trying to understand that.

On Mon, Oct 4, 2010 at 6:09 PM, Oliver Jowett <oliver@opencloud.com> wrote:
> Boris Partensky wrote:
>> Oh, this issue should probably be mentioned in
>> http://jdbc.postgresql.org/documentation/faq.html#upgradeTo80
>> document. It's pretty subtle and can bite someone hard.
>
> The thing that confuses me is that you said you also see the problem via
> psql - but psql isn't using parameterized queries at all (psql should be
> very similar to how the 7.3 driver executes queries, as in the 7.3 era
> the driver would do parameter substitution before sending a single query
> string to the server)
>
> -O
>

pgsql-jdbc by date:

Previous
From: Jeff Hubbach
Date:
Subject: Re: [BUGS] Mapping Hibernate boolean to smallint(Postgresql)
Next
From: Tim
Date:
Subject: JDBC type mappings