From: | "Marc G(dot) Fournier" <scrappy(at)hub(dot)org> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | OIDs missing in pg_attribute? |
Date: | 2001-12-07 02:47:22 |
Message-ID: | 20011206214346.G26397-100000@earth.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Morning all ...
Well, just spend the past few days banging my head against a brick
wall trying to figure out why OpenACS 4.x won't work with PgSQL v7.2b3,
and just figured it out, or, at least, figured out part of it ...
v7.2b3 no longer has an OID on pg_attribute?
The following works great in v7.1.3, but fails in v7.b3:
select upper(c.relname) as table_name,
upper(a.attname) as column_name,
d.description as comments
from pg_class c,
pg_attribute a
left outer join pg_description d on (a.oid = d.objoid)
where c.oid = a.attrelid
and a.attnum > 0;
In v7.1.3, it retuns:
table_name | column_name | comments
---------------------------------+-----------------+----------
PG_TYPE | TYPNAME |
PG_TYPE | TYPOWNER |
PG_TYPE | TYPLEN |
PG_TYPE | TYPPRTLEN |
PG_TYPE | TYPBYVAL |
PG_TYPE | TYPTYPE |
PG_TYPE | TYPISDEFINED |
PG_TYPE | TYPDELIM |
In v7.2b3, it returns:
ERROR: No such attribute or function 'oid'
arthur_acs=#
Is this intentional? :(
From | Date | Subject | |
---|---|---|---|
Next Message | mlw | 2001-12-07 05:06:01 | Re: Remote connections? |
Previous Message | Stephan Szabo | 2001-12-07 02:41:09 | Re: [SQL] how to change the type |