From: | "Shahab Asgharzadeh" <shahab(at)nwu(dot)edu> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | numeric type and odbc from access 2000 |
Date: | 2001-02-07 11:48:24 |
Message-ID: | LPBBKECACFKNGIBCAFPBIEPCCCAA.shahab@nwu.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Greetings,
I am a newcomer to postgresql and so far so good. Although some may argue
with
the use of Access in developing front-end clients, I have created one.
Everything
works well except when a table contains numeric datatype, one can not delete
rows
or update them from access.
I am using Postgress 7.01 on a SUN/solaris 8, using the postgres odbc 6.5,
and Access 2000 as the client.
The problem as I see it is when access is deleting a row it includes all the
columns within the sql statement instead of just using the primary key or
oid. That is:
a table with
col1 as integer
col2 as varchar(10)
col3 as numeric (9,3)
primary keys (col1, col2)
Access will write the sql as:
delete from "tablename" where "col1" = 1234 AND "col2" = 'text' AND "col3" =
100.200
It also seems that the problem can be duplicated within psql:
Given any table with a numeric type, if one includes the numeric column in
the delete or update statement you get:
ERROR: Unable to identify an operator '=' for types 'numeric' and 'float8'
You will have to retype this query using an explicit cast
Any ideas from anyone would be appreciate it, I hate to convert my numeric
column to an integer and divide by 1000 each time in order to solve this
problem.
Thanks
shahab
From | Date | Subject | |
---|---|---|---|
Next Message | Jamie Bumsted | 2001-02-07 12:53:13 | Can you help a newbie? |
Previous Message | Tamsin | 2001-02-07 11:25:01 | drop check constraint |