Postgres Pro
Downloads
Home   >   mailing lists

Problem with pg_dump and decimal mark - Mailing list pgsql-general

From Eric Svenson
Subject Problem with pg_dump and decimal mark
Date
Msg-id CABhsftgJVAa11-QuOK2aQaiJ2wrYhbqZvPfYzSstrUC_gYJSUg@mail.gmail.com
Whole thread Raw
Responses Re: Problem with pg_dump and decimal mark
List pgsql-general
Tree view
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



pgsql-general by date:

Previous
From: Teresa Bradbury
Date:
Subject: Synchronous Replication Timeout
Next
From: Adrian Klaver
Date:
Subject: Re: Problem with pg_dump and decimal mark