Re: Regression: Problems with Timestamp arguments - Mailing list pgsql-jdbc

From Vitalii Tymchyshyn
Subject Re: Regression: Problems with Timestamp arguments
Date
Msg-id CABWW-d3zq-Y3nkd3ra27mcaaeYPoF6OqjtUdBZf26qcTBGbBPg@mail.gmail.com
Whole thread Raw
In response to Re: Regression: Problems with Timestamp arguments  (Kris Jurka <books@ejurka.com>)
Responses Re: Regression: Problems with Timestamp arguments  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc

Why so? I thought if driver will pass timestamp with tz some queries won't work because of lack of implicit conversion, but I don't understand how can it corrupt anything.

11 вер. 2013 01:37, "Kris Jurka" <books@ejurka.com> напис.


On Tue, 10 Sep 2013, Lachezar Dobrev wrote:

>   I've made a blunt stab at working around the issue.
>   The attached patch adds a new parameter to the JDBC URL: timestamp.
> The parameter can be wither 'with_timezone' or 'without_timezone'. If
> the parameter is missing, or has a different value then the current
> behaviour (using Oid.UNSPECIFIED) is exhibited. With the parameters
> specified correctly one of the Oid.TIMESTAMP or Oid.TIMESTAMPTZ is
> used when sending Timestamp arguments to the server.

This won't really work in general though.  If you have a database that has
both timestamp and timestamptz fields in it, there is no valid setting of
this configuration option.  Setting it either way will result in silent
corruption of your data.

Kris Jurka


--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: 9.3 and extended constraint error information
Next
From: Thomas Kellerer
Date:
Subject: Re: 9.3 and extended constraint error information