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)

On Saturday 14 July 2007 00:04:08 Jim Nasby wrote:

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

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