Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group