| 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: | Whole Thread | Raw Message | 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 |