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

From Oliver Jowett
Subject Re: Upgrading JDBC driver from 7.3 to 8.4 affected execution plans
Date
Msg-id 4CAA5096.3040202@opencloud.com
Whole thread Raw
In response to Re: Upgrading JDBC driver from 7.3 to 8.4 affected execution plans  (Boris Partensky <boris.partensky@gmail.com>)
Responses Re: Upgrading JDBC driver from 7.3 to 8.4 affected execution plans  (Boris Partensky <boris.partensky@gmail.com>)
List pgsql-jdbc
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: Boris Partensky
Date:
Subject: Re: Upgrading JDBC driver from 7.3 to 8.4 affected execution plans
Next
From: stagirus
Date:
Subject: Re: [BUGS] Mapping Hibernate boolean to smallint(Postgresql)