Обсуждение: Re: [HACKERS] ODBC driver flakieness

> -----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.