Re: changing an update via rules

On 15 Jul 2003, Lauren Matheson wrote:

> Hello,
>
> I am having difficulty setting an on update rule which seems to be
> caught in a recursive loop.
>
> Context is a table with three columns assigning users to groups with the
> third column being boolean to flag the primary group. I would like to
> set an update rule to enforce one primary group. Any suggestions on how
> to do this, or exactly how the code is getting trapped? My code is

Rules are like macro rewrites and the WHERE clauses will not help to break
the recursive loop. I think you may need to either use a trigger or
something like a view so that the actual action happens on a different
table.