Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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.

pgsql-odbc by date

Next:From: Daniel A. KowalskiDate: 2001-09-25 19:26:49
Previous:From: Jean-Michel POUREDate: 2001-09-25 19:03:05
Subject: Re: [HACKERS] UTF-8 support

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group