Re: OIDs missing in pg_attribute?

"Marc G. Fournier" <scrappy(at)hub(dot)org> writes:
> v7.2b3 no longer has an OID on pg_attribute?

Yup.

> Is this intentional? :(

Yup.

> 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;

This would not work anyway in 7.2, since the primary key of
pg_description is now (objoid,classoid,objsubid) not just (objoid).
I'd recommend using col_description(a.attrelid, a.attnum) rather
than the explicit join against pg_description.

regards, tom lane