restore dump to 8.19

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

Responses

Browse pgsql-general by date

  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