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
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@xxxxxxxxx
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
