Re: [HACKERS] ODBC driver flakieness

>Just go into MS SQL and try creating a DTS job to migrate from MS SQL to
>Pgsql.  Have both fields (in ms and pg) be of type money.  In the
>destination the field type will show up as float4 instead of money.  If you
>try executing the job it will bomb saying that it is sending data in the
>wrong format (or something to that effect [i forget]).
Hello,

I had this problem before:
1) Try foat8 which is the normal mapping for money,
2) Make sure the local format of number are the same
Example : SQL Server 100.000,00 FHT  --> PostgreSQL US $100,000.00 will not
work.

Regards,
Jean-Michel POURE