From: | Tim Bosinius <tim(at)bosinius(dot)de> |
---|---|
To: | "'pgsql-interfaces(at)postgreSQL(dot)org'" <pgsql-interfaces(at)postgreSQL(dot)org> |
Subject: | another ODBC/Access question.. |
Date: | 1998-06-04 16:37:56 |
Message-ID: | 01BD8FE8.0612EC50.tim@bosinius.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 1998-06-04 17:06:52 | Re: libpgtcl bug (and symptomatic treatment) |
Previous Message | Dirk Lutzebaeck | 1998-06-04 15:22:52 | DBI/DBD-Pg 0.63 and 6.3.2 |