Postgres Pro
Downloads
Home   >   mailing lists

Thread: restore dump to 8.19

restore dump to 8.19

From
mljv@planwerk6.de
Date:
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

Re: restore dump to 8.19

From
Jim Nasby
Date:
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)

Re: restore dump to 8.19

From
Janning Vygen
Date:
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