I was trying to create a rule to set a column to false whenever another column was changed:
CREATE RULE...
ON UPDATE TO criterion
WHERE new.pattern::text <> old.pattern::text DO UPDATE table SET flag = false
WHERE id = old.id
pattern | id
12345 | 1
=> update criterion set pattern = '12345' where id = 1;
ERROR: infinite recursion detected in rules for relation "criterion"
I'm not sure why it's detecting recursion in this case when the rule conditional should be false
Thanks for any help...
gene