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: 4784C694.9020202@opencloud.com (view raw or flat)
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 
driver.

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

-O

In response to

Responses

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-2014 The PostgreSQL Global Development Group