Re: Problem migrating dump to latest CVS snapshot.

Tom Lane <tgl@sss.pgh.pa.us> writes:

> 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.

What do you mean by original value ? The value we have in the production
database ? If so, that shows up as 2000-10-24 15:14:60.00+02 independent of
what platform my client is running on. The production platform was as I
mentioned Solaris 2.7.

The value was generated at the time of a given web request by a Java
servlet and inserted into the database using JDBC. The timestamp in Java is
the number of milliseconds since epoch, so yes it is quite probable that it
contained a fractional second timestamp ;-)

But the problem here then might be with the Solaris 2.7 platform and not
Redhat Linux 6.1 if I am interpreting this right ???

Regards,

    Gunnar