Re: [GENERAL] restore dump to 8.19
On Jul 13, 2007, at 2:11 PM, [EMAIL PROTECTED] 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[EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] restore dump to 8.19
On Saturday 14 July 2007 00:04:08 Jim Nasby wrote: > On Jul 13, 2007, at 2:11 PM, [EMAIL PROTECTED] 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 ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/