Problem with pg_dump and decimal mark

Поиск
Список
Период
Сортировка
От Eric Svenson
Тема Problem with pg_dump and decimal mark
Дата
Msg-id CABhsftgJVAa11-QuOK2aQaiJ2wrYhbqZvPfYzSstrUC_gYJSUg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Problem with pg_dump and decimal mark
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Teresa Bradbury
Дата:
Сообщение: Synchronous Replication Timeout
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Problem with pg_dump and decimal mark