So, one more success... I have taken a part of the backup SQL file which fills the table
COPY dev_my_settings (.....) from stdin; 12345 text text 0 123.345345 This file ALONE works! (without changing ANYTHING!) So if I run the first (huge) SQL file and then the second, which fills the dev_my_settings table, everything is ok. 2014-12-10 10:23 GMT+01:00 Eric Svenson <esvenso...@googlemail.com>: > > The restore left you with two empty tables. What happens if you log into > Postgres > via psql and then INSERT one set of values containing floats > into say, >dev_my_settings? > > SUCCESS! This works OK! > > INSERT INTO dev_my_settings(123, 'test', 'test', 'test', 123, 123.345); > > Value 123.345 can be read from pg_admin. > > SHOW ALL shows English_United States.1252 for all lc_ settings (but I have > tried it with German and C locale with same results) > > Regards, Eric > > 2014-12-08 22:57 GMT+01:00 Adrian Klaver <adrian.kla...@aklaver.com>: > >> On 12/08/2014 06:53 AM, Eric Svenson wrote: >> >>> Hi Adrian, >>> >>> I try to get access to the non-VM machine, at the moment access is not >>> possible for me unfortunately. >>> >>> You are right, there are more tables in the database which are restored >>> correctly but these tables do NOT contain float values. These two tables >>> are the only tables in the database which contain floats. >>> >>> The errors occur with the first float in the table, the restore process >>> seems to terminate with that table and seems to continue with the next >>> table. The result are completely empty tables for dev_my_settings and >>> file_item. >>> >>> There are float values in the table which can be viewed with pg_admin. >>> >>> The table definitions for dev_my_settings and file_item contain lots of >>> BIGINTS, smallints and integers, and several double precision values. >>> All other tables do not contain any double precision values. >>> >> >> Alright a chance to think some more. >> >> So: >> >> The restore left you with two empty tables. What happens if you log into >> Postgres via psql and then INSERT one set of values containing floats into >> say, dev_my_settings? >> >> While you are in psql, what does SHOW ALL display for the lc_* settings? >> >> On the Windows server where the Postgres server is running what does SET >> show from the command line? >> >> >> >>> Regards, >>> Eric >>> >>> >>> >> >> -- >> Adrian Klaver >> adrian.kla...@aklaver.com >> > >
