[Oledb-dev] double precision error with pg linux server, but not with windows pg server

[Julian Heeb]

Shachar Shemesh schrieb:
> Julian Heeb wrote:
>   
>> Hello
>>
>> Our acounting software can use the PostgreSQL OLE DB driver to access
>> a postgreSQL database. With the pg server installed on windows,
>> everything works fine.
>>
>> I moved now the database to a postgreSQL server on a linux server, but
>> now every floating point number gets wrongly interpreted by the
>> acounting software, either by replacing it with a 0 or a very large
>> number (e.g. xxxE+308). Only the floating point numbers are affected,
>> integer or characters are correct. pgAdmin shows even the fp numbers
>> correctly, so I guess it has something to do with the pgoledb driver.
>>
>> Can someone give me a hint, how to solve the problem?
>>     
> It's hard to give a precise answer. Let's try a couple of venues.
>
> First of all, what platform is the Linux server? Is that an Intel, or
> something else?
>   
It is an ARM9 platform with Debian Etch (Linkstation Pro Fileserver with 
Freelink).
> Also, what is the precise type of the floating point var on the server?
> Can you give the SQL line that generated the table?
>   
The table has been generated by the following SQL line. The problem 
occures at the double precision fields.
I further observed that the values are correctly written into the table 
by the acounting software (psql and pgAdmin show the right values in the 
table), but are wrongly interpreted if they  are read from the db.

CREATE TABLE fib_buchungen
(
  abschreibung smallint,
  adressnradr integer,
  ankauffw double precision,
  ankaufsw double precision,
  anlagenrfib character varying(25),
  auftragnrpro character varying(25),
  banknrpro integer,
  bdatum date,
  beleg integer,
  belegartpro character varying(10),
  betragfw double precision,
  betragsw double precision,
  bewlaufnr integer,
  billid character varying(255),
  buartfib character varying(4),
  .
  .
  .
)

> Lastly, what version of the server are you running on Linux. Was it the
> same version on Windows?
>   
On Linux the version 8.1.8 is running and on windows 8.1.9


Thanks too,
Julian