Search Postgresql Archives

restore dump to 8.19

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux