> -----Original Message-----
> From: Gowey, Geoffrey [mailto:ggowey@rxhope.com]
> Sent: 25 September 2001 14:57
> To: 'Hiroshi Inoue'; Gowey, Geoffrey
> Cc: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] [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]).
IIRC, the money datatype is only in PostgreSQL now for backward
compatibility with older versions (as such I don't know how well the driver
will handle it). I believe it's generally recommended that the numeric type
be used instead.
Regards, Dave.
