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. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
