Re: [HACKERS] Rules for 6.4 finished

> >
> > >     This  is the final state of the rule system for 6.4 after the
> > >     patch is applied:
> >
> > This is all neat stuff Jan. Thanks for working on it...
> >
> >                      - Tom
>
>     After  playing  around  now with all that for a while I think
>     the only thing missing are some more attributes  in  the  new
>     views. Currently the views are:
>
>         view pg_rule (
>           rulename    name,    -- name of the rule in pg_rewrite
>           definition  text)    -- SQL statement that defines the rule
>
>         view pg_view (
>           viewname    name,    -- name of the view in pg_class
>           definition  text)    -- SELECT statement that defines the view
>
>     For  pg_rule  it would be nice to show up the event relations
>     name and it's owners name. So one can select only  the  rules
>     belonging  to  a specific table or all the rules one user had
>     created.   (this  is  already  possible   by   joining   with
>     pg_rewrite,  pg_class  and pg_user, but having the attributes
>     in pg_rule is easier)
>
>     For pg_view again the owners name would be nice.
>
>     Adding them would only require little changes  to  initdb.sh,
>     so  I  left  them  out  until  a discussion showed up all the
>     attributes that should be there.
>
>     Another topic is if we should create some more  system  views
>     at  initdb  time.  I  would  find views telling ownership and
>     other information readable instead of Oid's very  useful.  As
>     for pg_rule and pg_view it would be possible to create a view
>     that describes the definition of an  index  instead  of  some
>     cryptic  numbers.  And  another  one  for  real  tables where
>     indices and views are omitted would also be useful.

Yes, these are good ideas.

--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)