Dave Cramer <pg@fastcrypt.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