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

Re: Two bugs found (and patch included)

From: Kris Jurka <books(at)ejurka(dot)com>
To: Oliver Jowett <oliver(at)opencloud(dot)com>
Cc: pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Two bugs found (and patch included)
Date: 2005-01-18 21:58:06
Message-ID: Pine.BSO.4.56.0501181654410.7331@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-jdbc

On Wed, 19 Jan 2005, Oliver Jowett wrote:

> While testing this patch I noticed we have existing date-related 
> regression failures (not related to the patch) against 7.2.x:
> 
> Bad timestamp external representation '2000-02-08 04:00:00.120000+1300'

This appears to be an oddity of the +1300 timezone.  Both of the following 
work:

select '2000-02-07 15:00:00.120000+13'::timestamptz;
select '2000-02-07 15:00:00.120000+1200'::timestamptz;

We potentially could hack around this on the driver, but it looks to me 
like a server problem, so I'd leave it alone based on the number of people 
it affects (7.2 & +1300).

Kris Jurka

In response to

pgsql-jdbc by date

Next:From: Tom LaneDate: 2005-01-18 21:58:52
Subject: Re: Two bugs found (and patch included)
Previous:From: Oliver JowettDate: 2005-01-18 21:36:39
Subject: Re: Two bugs found (and patch included)

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