Re: Comments on columns in the pg_catalog tables/views

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: David Fetter <david(at)fetter(dot)org>
Cc: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Comments on columns in the pg_catalog tables/views
Date: 2005-10-13 02:15:48
Message-ID: 434DC354.1080209@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Yes for the love of god do it :D

David Fetter wrote:
> 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2005-10-13 02:29:32 Re: [COMMITTERS] pgsql: Do all accesses to shared buffer headers through
Previous Message Bruce Momjian 2005-10-13 01:27:46 Re: A costing analysis tool