isValid availability

From: Luis Flores <luiscamposflores(at)gmail(dot)com>
To: pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org>
Subject: isValid availability
Date: 2012-09-27 11:33:03
Message-ID: CA+nXnG8F=Phchnj-FC5_sL-w8RhhSO4XHt6wATfw3cyL0WExNg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2012-09-27 11:49:07 Re: isValid availability
Previous Message Stefan Reiser 2012-09-26 16:09:16 Re: Not able to insert array of integers into column of type integer array