Received: from keiko.petstore.com (IDENT:root@mail.petstore.com [208.25.91.9])
	by hub.org (8.9.3/8.9.3) with ESMTP id QAA06086
	for <pgsql-interfaces@postgresql.org>;
	Wed, 30 Jun 1999 16:49:35 -0400 (EDT)
	(envelope-from asif@petstore.com)
Received: from petstore.com (dhcp105.petstore.com [10.0.0.105])
	by keiko.petstore.com (8.8.7/8.8.7) with ESMTP id NAA29879
	for <pgsql-interfaces@postgresql.org>; Wed, 30 Jun 1999 13:54:39 -0700
Message-ID: <377A83E4.CA8D0105@petstore.com>
Date: Wed, 30 Jun 1999 13:53:56 -0700
From: "S. Asif Hassan" <asif@petstore.com>
X-Mailer: Mozilla 4.51 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: bug: Access sees money types incorrectly
Content-Type: multipart/mixed; boundary="------------1378C3CDCE69C23506E0260E"

This is a multi-part message in MIME format.
--------------1378C3CDCE69C23506E0260E
Content-Type: multipart/alternative;
	boundary="------------89226A4684421104C0F32CC6"


--------------89226A4684421104C0F32CC6
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

When I link a postgreSQL table into MS Access, Access sees data of type
'Money' as type 'Number' rather than as 'Currency'.  This is visible if
you pull up the design view for a linked table.  As a result of this
mismapping, any attempt to use Access to update records in the table
results in an error.


   * PostgreSQL ODBC driver version 6.40.0006
   * PostgreSQL database version 6.4
   * Access error message upon update attempt :

    ERROR: There is more than one possible operator '=' for types
'money' and 'float8'.  You will have to retype this query using an
explict cast
    (which is impossible as the query is generated by Access.)

   * commlog file attached - I have removed the server, port, dbase,
     user, and passwd for security purposes - sorry, but these should
     not be important bits of info.



--------------89226A4684421104C0F32CC6
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
When I link a postgreSQL table into MS Access, Access sees data of type
'Money' as type 'Number' rather than as 'Currency'.&nbsp; This is visible
if you pull up the design view for a linked table.&nbsp; As a result of
this mismapping, any attempt to use Access to update records in the table
results in an error.
<br>&nbsp;
<ul>
<li>
PostgreSQL ODBC driver version 6.40.0006</li>

<li>
PostgreSQL database version 6.4</li>

<li>
Access error message upon update attempt :</li>
</ul>
&nbsp;&nbsp;&nbsp; ERROR: There is more than one possible operator '='
for types 'money' and 'float8'.&nbsp; You will have to retype this query
using an explict cast
<br>&nbsp;&nbsp;&nbsp; (which is impossible as the query is generated by
Access.)
<ul>
<li>
commlog file attached - I have removed the server, port, dbase, user, and
passwd for security purposes - sorry, but these should not be important
bits of info.</li>
</ul>

<br>&nbsp;</html>

--------------89226A4684421104C0F32CC6--

--------------1378C3CDCE69C23506E0260E
Content-Type: application/x-unknown-content-type-txtfile;
	name="psqlodbc_90_modified.log"
Content-Transfer-Encoding: base64
Content-Disposition: inline;
 filename="psqlodbc_90_modified.log"

RFNOIGluZm86IERTTj0nUG9zdGdyZVNRTCcsc2VydmVyPScnLHBvcnQ9JycsZGJhc2U9Jycs
dXNlcj0nJyxwYXNzd2Q9JycNCiAgICAgICAgICByZWFkb25seT0nMCcscHJvdG9jb2w9JzYu
NCcsc2hvd29pZD0nMCcsZmFrZW9pZGluZGV4PScwJyxzaG93c3lzdGFibGU9JzAnDQogICAg
ICAgICAgY29ubl9zZXR0aW5ncz0nJw0KICAgICAgICAgIHRyYW5zbGF0aW9uX2RsbD0nJyx0
cmFuc2xhdGlvbl9vcHRpb249JycNCg==
--------------1378C3CDCE69C23506E0260E--