rule creating infinite recursion not sure why

Поиск
Список
Период
Сортировка
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 по дате отправления:

Предыдущее
От: "MG"
Дата:
Сообщение: Re: WARNING: some databases have not been vacuumed in 1953945422 transactions
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: Problem writing sql statement....