Re: Problem migrating dump to latest CVS snapshot.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gunnar R|nning <gunnar(at)candleweb(dot)no>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem migrating dump to latest CVS snapshot.
Date: 2001-03-22 23:24:04
Message-ID: 14331.985303444@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Gunnar R|nning <gunnar(at)candleweb(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2001-03-22 23:33:16 Re: Foreign keys/unique values and views
Previous Message Lydia Osborne 2001-03-22 22:51:00 Clarification of the extreme newbie questions

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Lockhart 2001-03-23 00:14:29 Re: Problem migrating dump to latest CVS snapshot.
Previous Message Trond Eivind =?iso-8859-1?q?Glomsr=F8d?= 2001-03-22 22:46:18 Re: Call for platforms