From: | mljv(at)planwerk6(dot)de |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | restore dump to 8.19 |
Date: | 2007-07-13 19:11:44 |
Message-ID: | 200707132111.44940.mljv@planwerk6.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Nasby | 2007-07-13 22:04:08 | Re: restore dump to 8.19 |
Previous Message | A. Kretschmer | 2007-07-13 18:11:36 | Re: multirow insert |