On Saturday 14 July 2007 00:04:08 Jim Nasby wrote: > On Jul 13, 2007, at 2:11 PM, mljv@xxxxxxxxxxxx wrote: > > i tried to restore a dump from version 8.1.8 to 8.1.9 and i had in > > one table > > a value "1.7383389519587511e-310" > > > > i got the following error message: > > > > pg_restore: ERROR: type "double precision" value out of range: > > underflow > > CONTEXT: COPY gesamtpunktecache, line 925001, column > > gc_gesamtsiege: "1.7383389519587511e-310" > > pg_restore: [archiver (db)] error returned by PQendcopy: ERROR: > > type "double > > precision" value out of range: underflow > > Is this on *identical* hardware, and were the binaries built the > same? Floating point stuff is very hardware dependent, and may have > some dependencies on compiler, etc as well. no, it was different hardware and maybe different compiler. Hmm, i do understand why computers are not masters of floating point (though i dont understand how they can fly air planes) , but a dump should be something which can be used across different hardware, shouldn't it? kind regards, janning
