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, Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
Subject: Re: Problem migrating dump to latest CVS snapshot.
Date: 2001-03-22 21:19:30
Message-ID: 13110.985295970@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'

I'll venture it doesn't like the "60" for seconds.

> The production platform creating the dump file is Solaris 7 on an Ultra
> Sparc, while the laptop I'm importing the file on is Redhat Linux 6.1 on an
> x86 processor.

Seems Mandrake Linux is not the only platform where roundoff behavior is
less IEEE-perfect than Thomas would like it to be. Perhaps we need a
slightly more robust approach to controlling roundoff error.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-03-22 21:40:05 Re: time representation bug
Previous Message J.H.M. Dassen Ray 2001-03-22 21:18:16 Re: Problem migrating dump to latest CVS snapshot.

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-03-22 21:38:59 Re: odbc/UnixWare 7.1.1: No Go.
Previous Message J.H.M. Dassen Ray 2001-03-22 21:18:16 Re: Problem migrating dump to latest CVS snapshot.