Re: Driver behaves differently with prepareThreshold and timestamp fields when daylights is active (was Re: Re: 9.4-1207 behaves differently with server side prepared statements compared to 9.2-1102)

From: Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)com>
To: Edson Richter <edsonrichter(at)hotmail(dot)com>
Cc: List <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Driver behaves differently with prepareThreshold and timestamp fields when daylights is active (was Re: Re: 9.4-1207 behaves differently with server side prepared statements compared to 9.2-1102)
Date: 2016-01-11 20:42:31
Message-ID: CAB=Je-EebMR4nuyn1Mf3iDNR2UeL_Tqmm8SHX1nLu7m+1RBN9A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

What is the field type?
timestamp? timestamp with time zone?

Are you using the latest java timezone updates? (tzupdater)

>As said before, since prepareThreshold=0 solved my problem

Then binaryTransferDisable=DATE,DATE_ARRAY,TIMESTAMP,TIMESTAMP_ARRAY,TIMESTAMPTZ,TIMESTAMPTZ_ARRAY,TIME,TIME_ARRAY,TIMETZ,TIMETZ_ARRAY
connection property might be better workaround.

Vladimir

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Edson Richter 2016-01-11 20:49:30 Re: Driver behaves differently with prepareThreshold and timestamp fields when daylights is active (was Re: Re: 9.4-1207 behaves differently with server side prepared statements compared to 9.2-1102)
Previous Message Tom Lane 2016-01-11 20:12:57 Re: strange CREATE INDEX tab completion cases

Browse pgsql-jdbc by date

  From Date Subject
Next Message Edson Richter 2016-01-11 20:49:30 Re: Driver behaves differently with prepareThreshold and timestamp fields when daylights is active (was Re: Re: 9.4-1207 behaves differently with server side prepared statements compared to 9.2-1102)
Previous Message Edson Richter 2016-01-11 19:59:13 Re: Driver behaves differently with prepareThreshold and timestamp fields when daylights is active (was Re: Re: 9.4-1207 behaves differently with server side prepared statements compared to 9.2-1102)