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

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

pgsql-jdbc by date

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

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