Re: Timestamp Conversion Woes Redux

From: Kris Jurka <books(at)ejurka(dot)com>
To: Dave Cramer <pg(at)fastcrypt(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Oliver Jowett <oliver(at)opencloud(dot)com>, Christian Cryder <c(dot)s(dot)cryder(at)gmail(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Timestamp Conversion Woes Redux
Date: 2005-07-19 16:06:36
Message-ID: Pine.BSO.4.56.0507191100110.68@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Tue, 19 Jul 2005, Dave Cramer wrote:

> What about creating two extension classes
>
> PGTimestamp, and PGTimestamptz
>
> then allowing setObject to recognize these internally and bind to
> Oid.Timestamp, and Oid.Timestamptz repectively
>

Who is going to really use these unportable things instead of standard
Timestamps? People who are desperate to get their application to work
around driver bugs? I don't believe timestamp/timestamptz is an
intractable problem and in the previous discussion I recall suggesting
setting the server time zone to match the client's would fix this problem.
I also seem to recall a number of other timezone related issues. Let's
focus on trying to fix what we've got before we go down this unportable
route. I'll put together at test cases for the bugs I'm aware of tonight
so we can focus this discussion on the real problems.

Kris Jurka

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Christian Cryder 2005-07-19 16:32:35 Re: Timestamp Conversion Woes Redux
Previous Message Csaba Nagy 2005-07-19 15:41:15 Re: Timestamp Conversion Woes Redux