From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Oliver Jowett <oliver(at)opencloud(dot)com> |
Cc: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: work in progress: timestamp patch |
Date: | 2005-07-26 11:33:15 |
Message-ID: | 4530E903-A144-4779-90CA-1477431E8280@fastcrypt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
On 26-Jul-05, at 6:23 AM, Oliver Jowett wrote:
> Dave Cramer wrote:
>
>> On 26-Jul-05, at 1:23 AM, Oliver Jowett wrote:
>>
>>> I looked at this and the current code is certainly wrong. The
>>> timezone
>>> offset of a Timestamp (deprecated method!) returns the offset of the
>>> JVM's default timezone always. We should indeed be passing the
>>> target
>>> calendar and using that.
>>>
>>> I've added that change to my patch. Interestingly none of the
>>> regression
>>> tests fail with it changed; we're very short on tests that
>>> actually test
>>> the with-Calendar code..
>>>
>> Well, I actually think this little change is more of the problem
>> than anything else.
>>
>
> I don't understand what you mean -- are you saying we shouldn't
> change this?
No, I think this may be the bug that causes it to fail currently. Not
that it shouldn't be overhauled. But this one is
probably the most significant "bug"
>
>
>> Did you manage to cobble together a patch for me to test ?
>>
>
> I'll send you a current snapshot in an hour or so. I got
> sidetracked into trying to work out the semantics of getDate() and
> getTime() on a timestamptz, still haven't found an entirely
> satisfactory solution..
OK.
> -O
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Peter.Zoche | 2005-07-26 13:19:53 | SQLException and error code |
Previous Message | Oliver Jowett | 2005-07-26 10:42:26 | Re: getObject(<oid>) returns integer instead of LargeObject |