| From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
|---|---|
| To: | Dave Cramer <pg(at)fastcrypt(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-18 23:13:48 |
| Message-ID: | 42DC37AC.5030704@opencloud.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Senthoorkumaran Punniamoorthy | 2005-07-19 08:56:40 | org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block |
| Previous Message | Oliver Jowett | 2005-07-18 23:11:01 | Re: Timestamp Conversion Woes Redux |