Re: Two bugs found (and patch included) - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Two bugs found (and patch included)
Date
Msg-id Pine.BSO.4.56.0501181654410.7331@leary.csoft.net
Whole thread Raw
In response to Re: Two bugs found (and patch included)  (Oliver Jowett <oliver@opencloud.com>)
List 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

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Two bugs found (and patch included)
Next
From: Tom Lane
Date:
Subject: Re: Two bugs found (and patch included)