| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | "Robert Kruuus" <robert(dot)kruus(at)gov(dot)sk(dot)ca>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: BUG #4789: ERROR 22008 on timestamp import |
| Date: | 2009-05-01 17:54:36 |
| Message-ID: | 49FAF10C.EE98.0025.0@wicourts.gov |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
>>> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-05-01 18:12:23 | Re: BUG #4789: ERROR 22008 on timestamp import |
| Previous Message | Tom Lane | 2009-05-01 17:49:35 | Re: BUG #4789: ERROR 22008 on timestamp import |