Re: Fwd: Fwd: Problem with pg_dump and decimal mark

Hi Adrian,

here are the results of today:

> How where the Postgres instances installed?
> From a package?

Yes. It is Version 9.2 for Windows, comment of the package is
"The PostgreSQL RDBMS, version 9.2, packaged by EnterpriseDB"

> Compiled and if so with what compiler and what settings?
No.

> Use --inserts with pg_dump to get INSERT statements instead of a COPY and
then feed to psql.
> This will slow the process down, so I would try with a small sample set.

Much slower, but still the same error:

(part of the output)

INSERT 50415934 1
INSERT 50415935 1
INSERT 50415936 1
INSERT 50415937 1
INSERT 50415938 1
INSERT 50415939 1
ERROR: invalid input syntax for type double precision:
"0.10000000000000001"

> Do pg_dump -Fc and then use pg_restore.

pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 2558; 0 5161040 TABLE DATA
dev_my_settings my_Database
pg_restore: [archiver (db)] COPY failed for table "dev_my_settings":
ERROR: invalid input syntax
for type double precision: "0.10000000000000001"
CONTEXT: COPY dev_meas_settings, line 718, column dms_dble_value:
"0.10000000000000001"
pg_restore: [archiver (db)] Error from TOC entry 2552; 0 5160884 TABLE DATA
file_item my_Database
pg_restore: [archiver (db)] COPY failed for table "file_item": ERROR:
invalid input syntax for type
double precision: "48.200082999999999"
CONTEXT: COPY file_item, line 54, column fi_latitude: "48.200082999999999"
WARNING: errors ignored on restore: 2

Regards,
Eric

2014-12-05 16:22 GMT+01:00 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>:

> On 12/05/2014 01:13 AM, Eric Svenson wrote:
>
>>
>>
>> Hi Adrian,
>>
>> Is the above how the message was actually presented or has a
>>> partialtranslation taken >place? Just asking because it would seem to
>>> indicate
>>>
>> further confusion about the locale.
>>
>> This is an exact copy of the screen contents, no translation by me has
>> taken place. Indeed strange, "ERROR" (english) "KONTEXT" (german, one
>> line below) ??
>>
>> To add further confusion: I have a report that the error also appeared
>> on a non-VM native PC with Windows 7 Enterprise. Unfortunately, I dont
>> have the exact error message, but I try to get it ASAP.
>>
>
> Well nothing came back to me on VMware and locales, but that does not seem
> to be the issue if the above is correct.
>
> So:
>
> How where the Postgres instances installed?
> From a package?
> Compiled and if so with what compiler and what settings?
>
> What happens if you?:
>
> Use --inserts with pg_dump to get INSERT statements instead of a COPY and
> then feed to psql.
> This will slow the process down, so I would try with a small sample set.
>
> Do pg_dump -Fc and then use pg_restore.
>
> The above are more a way of seeing if the issue is on a particular path or
> is generic, than a solution.
>
>
>
>> regards,
>> Eric Svenson
>>
>>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>