out of range error while restore using pgdump

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

 



Hello,
We are migrating database from one server to another.
As such we are not making any changes in the database structure.
Stil getting below error while restore using pgdump.


pg_restore: [archiver (db)] COPY failed for table "tcb_test": ERROR:  "5.40593839802118076e-315" is out of range for type double precision
CONTEXT:  COPY tcb_test, line 3932596, column va_odometro: "5.40593839802118076e-315"

Could you please help us how can we avoid solve this error?

postgres version 9.5 
OS: Red hat 7.1

Thanks,
Samir Magar

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux