Re: [HACKERS] ODBC driver flakieness

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.

Browse pgsql-odbc by date

  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