>     Anyway,  what's  the preferred syntax for triggering the rule
>     recompilation?  I thought about
> 
>         ALTER RULE {rulename|ALL} RECOMPILE;
> 
>     Where ALL triggers only those rules where the  user  actually
>     has RULE access right on a relation.

In good world rules (PL functions etc) should be automatically
marked as dirty (ie recompilation required) whenever referenced
objects are changed.

Vadim

Thu, 12 Jul 2001 10:41:00 -0700
"Mikheev, Vadim" <vmikheev@SECTORBASE.COM>
RE: Rule recompilation
Mikheev, Vadim wrote:
> >     Anyway,  what's  the preferred syntax for triggering the rule
> >     recompilation?  I thought about
> >
> >         ALTER RULE {rulename|ALL} RECOMPILE;
> >
> >     Where ALL triggers only those rules where the  user  actually
> >     has RULE access right on a relation.
>
> In good world rules (PL functions etc) should be automatically
> marked as dirty (ie recompilation required) whenever referenced
> objects are changed.

    Yepp,  and  it'd  be possible for rules (just not right now).
    But we're not in  a  really  good  world,  so  it'll  not  be
    possible for PL's.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


Thu, 12 Jul 2001 13:57:02 -0400 (EDT)
Jan Wieck <JanWieck@Yahoo.com>
Re: Rule recompilation