From: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "'Gowey, Geoffrey'" <ggowey(at)rxhope(dot)com>, "'Hiroshi Inoue'" <Inoue(at)tpf(dot)co(dot)jp> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: [HACKERS] ODBC driver flakieness |
Date: | 2001-09-25 19:24:49 |
Message-ID: | AA30E7BCCA5C1D4E88A231900F8325C00B1F@dogbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
> -----Original Message-----
> From: Gowey, Geoffrey [mailto:ggowey(at)rxhope(dot)com]
> Sent: 25 September 2001 14:57
> To: 'Hiroshi Inoue'; Gowey, Geoffrey
> Cc: pgsql-odbc(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel A. Kowalski | 2001-09-25 19:26:49 | SQLSERVER |
Previous Message | Jean-Michel POURE | 2001-09-25 19:03:05 | Re: [HACKERS] UTF-8 support |