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: Edson Richter <edsonrichter(at)hotmail(dot)com>
To:
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:49:30
Message-ID: BLU436-SMTP25A0B963BD204F4D9E598CCFC90@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

This is really interesting.
I would give a try.

Regards,

Atenciosamente,

Edson Carlos Ericksson Richter

Em 11/01/2016 18:42, Vladimir Sitnikov escreveu:
> 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 Vladimir Sitnikov 2016-01-11 20:54:10 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 Vladimir Sitnikov 2016-01-11 20:42:31 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)

Browse pgsql-jdbc by date

  From Date Subject
Next Message Vladimir Sitnikov 2016-01-11 20:54:10 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 Vladimir Sitnikov 2016-01-11 20:42:31 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)