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

Re: Timestamps without time zone

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Timestamps without time zone
Date: 2008-01-09 13:05:24
Message-ID: (view raw or whole thread)
Lists: pgsql-jdbc
Achilleas Mantzios wrote:

>> Which driver version are you using?
> Its the 7.4.19 built from source. 

Ah, there is your problem then. That is a very old driver and had 
problems with exactly the case you're trying to use (setTimestamp() with 
a Calendar), amongst many other bugs.

Can you try a recent driver and see if it fixes your problem? Looking at 
CVS history it looks like 8.1 is the earliest driver with 
timezone-related fixes, but I'd suggest you try the most recent stable 

Newer drivers will still talk to older servers, so you shouldn't need to 
upgrade your server to test this.


In response to


pgsql-jdbc by date

Next:From: Achilleas MantziosDate: 2008-01-09 13:12:25
Subject: Re: Timestamps without time zone
Previous:From: Achilleas MantziosDate: 2008-01-09 12:56:29
Subject: Re: Timestamps without time zone

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