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

Re: Problems with infinity

From: Kris Jurka <books(at)ejurka(dot)com>
To: Oliver Siegmar <o(dot)siegmar(at)vitrado(dot)de>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Problems with infinity
Date: 2005-02-04 09:27:21
Message-ID: Pine.BSO.4.56.0502040418140.17928@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-jdbc

On Fri, 4 Feb 2005, Oliver Siegmar wrote:

> To track down the problem (infinity in another timezone) I changed the 
> timezone of my PgSQL server from 'CET' to 'EST'. Even without the 
> infinity-patch applied I get a test-exception:
> 
> testGetTimestampWTZ(org.postgresql.test.jdbc2.TimestampTest):     FAILED
>     [junit] expected:<-627872399900> but was:<-627847199900>

This is a known problem when you have timestamp without time zone and the 
server and client timezone is different.  If you set your client timezone 
to EST as well it should go away.

http://archives.postgresql.org/pgsql-jdbc/2004-12/msg00137.php

Kris Jurka

In response to

pgsql-jdbc by date

Next:From: Peter EisentrautDate: 2005-02-04 09:54:16
Subject: Re: BUG #1459: Connection hangs when other connection is not committed
Previous:From: Oliver SiegmarDate: 2005-02-04 09:12:03
Subject: Re: Problems with infinity

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