Folks, Before I dive into this, is there some reason why the pg_catalog.* tables/views should not have comments that match the descriptions in the docs? I can see where this could cause some maintenance issues, and those probably need to be addressed, but it sure would be nice if \d+ pg_depend pulled up something like:
Table "pg_catalog.pg_depend" Column | Type | Modifiers | Description -------------+---------+-----------+------------- classid | oid | not null | The OID of the system catalog the dependent object is in objid | oid | not null | The OID of the specific dependent object objsubid | integer | not null | For a table column, this is the column number (the objid and classid refer to the table itself). For all other object types, this column is zero. refclassid | oid | not null | The OID of the system catalog the referenced object is in refobjid | oid | not null | The OID of the specific referenced object refobjsubid | integer | not null | For a table column, this is the column number (the refobjid and refclassid refer to the table itself). For all other object types, this column is zero. deptype | "char" | not null | A code defining the specific semantics of this dependency relationship; see text. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match