OIDs missing in pg_attribute?
От | Marc G. Fournier |
---|---|
Тема | OIDs missing in pg_attribute? |
Дата | |
Msg-id | 20011206214346.G26397-100000@earth.hub.org обсуждение исходный текст |
Ответы |
Re: OIDs missing in pg_attribute?
Re: OIDs missing in pg_attribute? Re: OIDs missing in pg_attribute? |
Список | 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_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? :(
В списке pgsql-hackers по дате отправления: