RE: Rule recompilation - Mailing list pgsql-hackers

From Mikheev, Vadim
Subject RE: Rule recompilation
Date
Msg-id 3705826352029646A3E91C53F7189E320166C6@sectorbase2.sectorbase.com
Whole thread Raw
In response to Rule recompilation  (Jan Wieck <JanWieck@Yahoo.com>)
Responses Re: Rule recompilation  (Jan Wieck <JanWieck@Yahoo.com>)
List pgsql-hackers
>     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


pgsql-hackers by date:

Previous
From: "Mikheev, Vadim"
Date:
Subject: RE: Re: Strangeness in xid allocation / snapshot setup
Next
From: "Mikheev, Vadim"
Date:
Subject: RE: Rule recompilation