Received: from mail.id-pro.net (qmailr@mail.id-pro.net [195.52.215.12]) by hub.org (8.8.8/8.7.5) with SMTP id MAA20895 for ; Thu, 4 Jun 1998 12:34:15 -0400 (EDT) Received: (qmail 25779 invoked from network); 4 Jun 1998 16:34:03 -0000 Received: from ts1-f3.kunden.id-pro.net (HELO automatix) (195.52.215.195) by medusa.id-pro.net with SMTP; 4 Jun 1998 16:34:03 -0000 Received: by localhost with Microsoft MAPI; Thu, 4 Jun 1998 18:38:53 +0200 Message-ID: <01BD8FE8.0612EC50.tim@bosinius.de> From: Tim Bosinius To: "'pgsql-interfaces@postgreSQL.org'" Subject: another ODBC/Access question.. Date: Thu, 4 Jun 1998 18:37:56 +0200 X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 Encoding: 23 TEXT When connecting Access97 to a postgreSQL datasource with ODBC the pg_attribute.attnuotnull is not queried and therefore not set in Access. this is in the psqlodbc logfile: conn=154147544, query='BEGIN' conn=154147544, query='declare SQL_CUR154411144 cursor for select u.usename, c.relname, a.attname, a.atttypid,t.typname, a.attnum, a.attlen, a.atttypmod from pg_user u, pg_class c, pg_attribute a, pg_type t where int4out(u.usesysid) = int4out(c.relowner) and .oid= a.attrelid and a.atttypid = t.oid and (a.attnum > 0) and c.relname like 'test' order by attnum' conn=154147544, query='fetch 100 in SQL_CUR154411144' [ fetched 2 rows ] conn=154147544, query='close SQL_CUR154411144' conn=154147544, query='END' Is this a bug in the ODBC driver or an Access problem? Tim Bosinius