From: S. Asif Hassan <asif@petstore.com>
To: pgsql-interfaces@postgresql.org
Subject: bug: Access sees money types incorrectly
Date: Wed, 30 Jun 1999 13:53:56 -0700
Message-ID: <377A83E4.CA8D0105@petstore.com> (raw)
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.
Attachments:
psqlodbc_90_modified.log (application/x-unknown-content-type-txtfile, 238B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: asif@petstore.com
Subject: Re: bug: Access sees money types incorrectly
In-Reply-To: <377A83E4.CA8D0105@petstore.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox