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.kla...@aklaver.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.kla...@aklaver.com >
