OIDs missing in pg_attribute?

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

Responses

Browse pgsql-hackers by date

  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