rule creating infinite recursion not sure why - Mailing list pgsql-general

From Gene
Subject rule creating infinite recursion not sure why
Date
Msg-id 430d92a20702152332v61d0bcc4pf26e92a3df849d43@mail.gmail.com
Whole thread Raw
Responses Re: rule creating infinite recursion not sure why
Re: rule creating infinite recursion not sure why
Re: rule creating infinite recursion not sure why
List pgsql-general
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

pgsql-general by date:

Previous
From: "MG"
Date:
Subject: Re: WARNING: some databases have not been vacuumed in 1953945422 transactions
Next
From: Ron Johnson
Date:
Subject: Re: Problem writing sql statement....