Re: Problem migrating dump to latest CVS snapshot. - Mailing list pgsql-general

From Tom Lane
Subject Re: Problem migrating dump to latest CVS snapshot.
Date
Msg-id 14331.985303444@sss.pgh.pa.us
Whole thread Raw
In response to Problem migrating dump to latest CVS snapshot.  (Gunnar R|nning <gunnar@candleweb.no>)
List pgsql-general
Gunnar R|nning <gunnar@candleweb.no> writes:
> ERROR:  copy: line 154391, Bad timestamp external representation '2000-10-24 15:14:60.00+02'

BTW, did your original data contain any fractional-second timestamps?
I'm wondering if the original value might have been something like
    2000-10-24 15:14:59.999
in which case sprintf's roundoff of the seconds field to %.2f format
would've been enough to do the damage.

            regards, tom lane

pgsql-general by date:

Previous
From: Lydia Osborne
Date:
Subject: Clarification of the extreme newbie questions
Next
From: Jan Wieck
Date:
Subject: Re: Foreign keys/unique values and views