Re: restore dump to 8.19

On Saturday 14 July 2007 00:04:08 Jim Nasby wrote:
> On Jul 13, 2007, at 2:11 PM, mljv(at)planwerk6(dot)de 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