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_classc, 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? :(