>>> Tom Lane <tgl@sss.pgh.pa.us> wrote:
> but I bet it's the change in the default integer_datetimes setting
> that is the relevant difference.
Confirmed.
cc=> select '1999-08-06 00:12:57.999999900Z'::timestamptz;
ERROR: date/time field value out of range: "1999-08-06
00:12:57.999999900Z"
cc=> select version();
version
-----------------------------------------------------------------------------------------------------
PostgreSQL 8.3.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc
(GCC) 4.1.2 20070115 (SUSE Linux)
(1 row)
cc=> show integer_datetimes ;
integer_datetimes
-------------------
on
(1 row)
-Kevin