Re: Upgrading JDBC driver from 7.3 to 8.4 affected execution plans

From: Boris Partensky <boris(dot)partensky(at)gmail(dot)com>
To: Oliver Jowett <oliver(at)opencloud(dot)com>
Cc: Maciek Sakrejda <msakrejda(at)truviso(dot)com>, PG-JDBC Mailing List <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Upgrading JDBC driver from 7.3 to 8.4 affected execution plans
Date: 2010-10-05 01:33:20
Message-ID: AANLkTi=hA5R+REbnsWpB9zYrfyd6cbGL5vQgpCHJnkg-@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)opencloud(dot)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
>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message stagirus 2010-10-05 10:41:50 Re: [BUGS] Mapping Hibernate boolean to smallint(Postgresql)
Previous Message Oliver Jowett 2010-10-04 22:09:26 Re: Upgrading JDBC driver from 7.3 to 8.4 affected execution plans