Re: 'Bad timestamp external representation' error when restoring database - Mailing list pgsql-general

From Tom Lane
Subject Re: 'Bad timestamp external representation' error when restoring database
Date
Msg-id 27023.1031147645@sss.pgh.pa.us
Whole thread Raw
In response to 'Bad timestamp external representation' error when restoring database  (Søren Neigaard <s.neigaard@mobilethink.dk>)
List pgsql-general
=?iso-8859-1?Q?S=F8ren_Neigaard?= <s.neigaard@mobilethink.dk> writes:
> ERROR:  copy: line 3580, Bad timestamp external representation '2002-08-23
> 08:31:60.00+02'
> PQendcopy: resetting connection

This is a known bug in older PG releases: sometimes a time like
"08:31:59.999" is mistakenly rounded off as "08:31:60.00" which of course
the timestamp reader code thinks is bogus.  I'm afraid you have little
choice but to edit the dump file to fix the broken timestamps (a sed
script might help here).

You should think about updating to a more recent release ---
AFAIK this problem is fixed in 7.2.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Please help - Keep getting authentication failure when trying to restore database
Next
From: Tom Lane
Date:
Subject: Re: clog problem