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