Re: BUG #4789: ERROR 22008 on timestamp import - Mailing list pgsql-bugs

>>> 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