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.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======================================== jwieck(at)debis(dot)com (Jan Wieck) #