Hello,
I have done a backup of a postgres database on a virtual machine (Windows
8.1) using pg_dump.
On another (non-virtual) machine the restore (with psql) worked without
problems.
On the third virtual machine, however, the restore fails.
(ERROR: invalid input syntax for type double precision: 0.100000000001)
When I change the value in the sql file manually to 0,100000000001 the and
try again, the restore resumes until the next double value.
How is this possible? Does psql really expect comma-seperated decimal
values in the sql file? How can I change this behaviour?
Regards,
Eric Svenson