Re: isValid availability

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Luis Flores <luiscamposflores(at)gmail(dot)com>
Cc: pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: isValid availability
Date: 2012-09-27 11:49:07
Message-ID: CADK3HHJ+D6y1zz+w0R98DFkWx+swO60j1DeRQDdRM3-_yy1vEg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Luis,

Other than my mistakes, there is no reason.

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca

On Thu, Sep 27, 2012 at 7:33 AM, Luis Flores <luiscamposflores(at)gmail(dot)com> wrote:
> Hello,
>
> The method isValid is implemented and committed since 2012-01-19 by
> Dave Cramer, however, it isn't available on the driver version 901 and
> 902.
>
> Any reason why?
>
> On the same subject, the implementation is using SELECT 1; because it
> was the simplest query returning a value, simply issuing an "" won't
> guarantee to go to the back-end (it may go for now, but it depends on
> the driver bottom layer to issue it to the back-end. And the is no
> real performance advantage from "" to "SELECT 1" since no one is going
> to call isValid hundreds of times a second.
>
> I also noted that the driver release dates on the site are incorrect
> (http://jdbc.postgresql.org/changes.html) for driver 901 and 902
> (copy/paste is evil).
>
> Thank you all,
>
> Luis Flores
>
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Florent Guillaume 2012-09-27 13:02:19 Re: Bug in AbstracJdbc2Statement.replaceProcessing when using dollar quoting?
Previous Message Luis Flores 2012-09-27 11:33:03 isValid availability