Re: restore dump to 8.19

On Jul 13, 2007, at 2:11 PM, mljv@planwerk6.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
> CONTEXT:  COPY gesamtpunktecache, line 925001, column
> gc_gesamtsiege: "1.7383389519587511e-310"
>
> i tried to insert a value of "1.7383389519587511e-310" to a 8.18
> database but
> i didn't manage it (with the same error message). But in one of my
> databases
> i can select a value like this.
>
> very strange. i just wanted to told you just in case it is of any
> interest and
> maybe i can help with further informations.

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.
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)