Re: Regression: Problems with Timestamp arguments

Поиск
Список
Период
Сортировка
От Vitalii Tymchyshyn
Тема Re: Regression: Problems with Timestamp arguments
Дата
Msg-id CABWW-d3zq-Y3nkd3ra27mcaaeYPoF6OqjtUdBZf26qcTBGbBPg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Regression: Problems with Timestamp arguments  (Kris Jurka <books@ejurka.com>)
Ответы Re: Regression: Problems with Timestamp arguments  (Kris Jurka <books@ejurka.com>)
Список 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 по дате отправления:

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Re: 9.3 and extended constraint error information
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: 9.3 and extended constraint error information