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

S1002: Invalid column number in ColAttributes

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 (view raw or flat)
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 


Responses

pgsql-odbc by date

Next:From: DI HasenöhrlDate: 2001-07-30 11:23:35
Subject: Problem:Row Versioning with multiple field Primary Key
Previous:From: Jussi JaaskelainenDate: 2001-07-30 09:34:25
Subject: odbc and bit-field

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