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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-jdbc by date

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