From: | "Joseph" <lters(at)mrtc(dot)com> |
---|---|
To: | "Pgsql-Odbc(at)Postgresql(dot)Org" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | S1002: Invalid column number in ColAttributes |
Date: | 2001-07-30 11:06:44 |
Message-ID: | 001c01c118e7$b9202c50$1a01a8c0@SS1 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
I get this error in ms access 97
S1002: Invalid column number in ColAttributes.;
any time I try to do complex query that includes fields that are a
combination of fields.
Where does this error come from and how can I fix it?
I notice that access calls the query in postgres,
there is no error but
immediately access queries postgres like this:
select u.usename, c.relname, a.attname, a.atttypid, t.typname, a.attnum,
a.attlen, a.atttypmod, a.attnotnull, c.relhasrules from pg_user u,
pg_class c, pg_attribute a, pg_type t where u.usesysid = c.relowner and
c.oid= a.attrelid and a.atttypid = t.oid and (a.attnum > 0) and
c.relname like 'tbl_family' order by attnum
which seems to indicate that it wants to verify that all the returned
field names are the way it thinks they should be...
respectfully,
Joseph
From | Date | Subject | |
---|---|---|---|
Next Message | DI Hasenöhrl | 2001-07-30 11:23:35 | Problem:Row Versioning with multiple field Primary Key |
Previous Message | Jussi Jaaskelainen | 2001-07-30 09:34:25 | odbc and bit-field |