On 11 August 2015 at 11:00, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Dave Cramer <pg(at)fastcrypt(dot)com> writes:
> > Here are the comments in the code.
> > // We must use UNSPECIFIED here, or inserting a Date-with-timezone
> into a
> > // timestamptz field does an unexpected rotation by the server's
> TimeZone:
>
> Ugh. But why not send it as a timestamptz?
>
> Unfortunately we do the same thing with times and timestamps.
We don't parse the sql so we don't know if there is TZ information.
If the underlying column is a timestamp and we set the oid to timstamptz
then it fails. IIRC