=?iso-8859-1?Q?S=F8ren_Neigaard?= <s(dot)neigaard(at)mobilethink(dot)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