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

[Shachar Shemesh]

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?

Also, what is the precise type of the floating point var on the server?
Can you give the SQL line that generated the table?

Lastly, what version of the server are you running on Linux. Was it the
same version on Windows?

Thanks,
Shachar