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

Bug #556: Problem with ODBC Driver Version 7.1.9, DB Version 7.1.3

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #556: Problem with ODBC Driver Version 7.1.9, DB Version 7.1.3
Date: 2002-01-08 10:42:44
Message-ID: 200201081042.g08Agif35386@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Wolfgang Frtbauer (w(dot)fuertbauer(at)eunet(dot)at) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
Problem with ODBC Driver Version 7.1.9, DB Version 7.1.3

Long Description
created table umsatz:

fakt32=# \d umsatz
                                     Table "umsatz"
 Attribute  |         Type          |                      Modifier             
------------+-----------------------+----------------------------------------------------
 inr        | integer               | not null default nextval('"umsatz_inr_seq"'::text)
 kdnr       | bigint                | default 0
 jahr       | integer               | default 0
 menge      | real                  | default 0
 netto      | real                  | default 0
 nettostamm | real                  | default 0
 kz         | character varying(2)  |
 kolltext   | character varying(30) |
 agtext     | character varying(30) |
 rabproz    | real                  | default 0
Indices: umsatz_kdnr_key,
         umsatz_pkey

as you can see: field "kdnr" is defined as bigint;

using MsAccess as frontend; connecting tables via ODBC (Driver Version 7.1.9);

field "kdnr" is shown as type text length(19) ????


Sample Code
"Select * from umsatz where kdnr = 2" gives Error-Message: Data Type mismatch in criteria expression.


No file was uploaded with this report


pgsql-bugs by date

Next:From: pgsql-bugsDate: 2002-01-08 14:45:54
Subject: Bug #557: triggers tablename are not rename if table are renamed.
Previous:From: pgsql-bugsDate: 2002-01-08 09:51:16
Subject: Bug #555: Lock-problem via ODBC

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