
If you define a database field like this with the "without time zone" 
clause.....

created timestamp(6) without time zone DEFAULT 'now' NOT NULL,

Then the current postgresql jdbc driver falls over in a heap when trying 
to select and retrieve this field.






Tue, 25 Jun 2002 16:42:11 +1000
Chris Bitmead <chris@bitmead.com>
Definite bug in JDBC
Chris,

This should have been posted to pgsql-jdbc instead of hackers.

Can you define what you mean by 'current postgresql jdbc driver'?  There 
are some bugs in the 7.2 driver that are fixed in current sources.  Have 
you tried the latest development driver from the jdbc.postgresql.org web 
site?

Can you define what you mean by 'falls over in a heap'?  The actual 
error message would really be useful.

I can't seem to be able to reproduce your problem running the latest 
development driver against a 7.2.1 database.

thanks,
--Barry

Chris Bitmead wrote:

>
> If you define a database field like this with the "without time zone" 
> clause.....
>
> created timestamp(6) without time zone DEFAULT 'now' NOT NULL,
>
> Then the current postgresql jdbc driver falls over in a heap when 
> trying to select and retrieve this field.
>
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
>
>





Tue, 25 Jun 2002 09:11:42 -0700
Barry Lind <barry@xythos.com>
Re: [HACKERS] Definite bug in JDBC