Обсуждение: restore dump to 8.19
Hi 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. kind regards, janning
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