From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Oliver Jowett <oliver(at)opencloud(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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 12:19:08 |
Message-ID: | C36F2D5F-093E-489C-8D6F-A67B746EA6C8@fastcrypt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
I'm also thinking we should use UNKOWN for setString as well,
hopefully this would reduce the number of upgrade problems people are
having when they upgrade from 7.x to 8.x
Dave
On 18-Jul-05, at 7:13 PM, Oliver Jowett wrote:
> Dave Cramer wrote:
>
>
>> You are correct, the driver is binding it to a timestamptz. The
>> underlying data is without
>> timezone so the server probably attempts to remove it
>>
>> I'm starting to think that binding the type to "unknown" might be
>> better as you suggested earlier.
>>
>
> Yeah, given that we can't work out which of the two types is intended
> ahead of time, this might be the best idea..
>
> Christian, you should be able to test this easily enough by modifying
> setTimestamp() to pass Oid.UNKNOWN instead of Oid.TIMESTAMPTZ to
> bindString().
>
> -O
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Jowett | 2005-07-19 12:23:37 | Re: Timestamp Conversion Woes Redux |
Previous Message | Oliver Jowett | 2005-07-19 12:16:24 | Re: org.postgresql.util.PSQLException: ERROR: current transaction |