Re: Idea: Comments on system catalogs? - Mailing list pgsql-hackers

From Dawid Kuroczko
Subject Re: Idea: Comments on system catalogs?
Date
Msg-id 758d5e7f0803091055s46f190d4l70264c696c6aa5f6@mail.gmail.com
Whole thread Raw
In response to Re: Idea: Comments on system catalogs?  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
On Fri, Mar 7, 2008 at 3:51 PM, Bruce Momjian <bruce@momjian.us> wrote:
~> Jim C. Nasby wrote:
> > On Wed, Jul 04, 2007 at 01:03:20PM +0200, Dawid Kuroczko wrote:
>  > > Hello.
>  > >
>  > > I think it could be a nice idea to put descriptions from
>  > > http://www.postgresql.org/docs/8.2/static/catalogs.html
>  > > into system catalogs itself.  I.e., make a bunch of
>  > >
>  > > COMMENT ON COLUMN pg_class.relname
>  > >    IS 'Name of the table, index, view, etc.';
>  > > ...
>  > > COMMENT ON COLUMN pg_class.relkind
>  > >    IS 'r = ordinary table, i = index, S = sequence, v = view, c =
>  > > composite type, t = TOAST table';
>  > >
>  > Actually, this does exist for some things in the catalog; I suspect it
>  > just wasn't done in the past (perhaps Postgres didn't originally have
>  > comments). I think it would be a useful addition. But I think it'd need
>  > to be more than just a .sql file (initdb would probably need to be
>  > modified). Ideally, we'd be able to suck the info out of the appropriate
>  > .sgml files.
>
>  Added to TODO:
>
>  * Add comments on system tables/columns using the information in
>   catalogs.sgml
>
>   Ideally the information would be pulled from the SGML file
>   automatically.

Since I have raised the issue back then, I volunteer for doing this TODO.

As I am lazy by nature, I am sure I will try to use SGML files instead of
tediuos copy&paste routine. ;-)
  Regards,     Dawid


pgsql-hackers by date:

Previous
From: Andrew Chernow
Date:
Subject: Re: timestamp datatype cleanup
Next
From: Tom Lane
Date:
Subject: Re: Lazy constraints / defaults