rule creating infinite recursion not sure why

Поиск
Список
Период
Сортировка
От Gene
Тема rule creating infinite recursion not sure why
Дата
Msg-id 430d92a20702152332v61d0bcc4pf26e92a3df849d43@mail.gmail.com
обсуждение исходный текст
Ответы Re: rule creating infinite recursion not sure why  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: rule creating infinite recursion not sure why  (Andreas Kretschmer <akretschmer@spamfence.net>)
Re: rule creating infinite recursion not sure why  (Alvaro Herrera <alvherre@commandprompt.com>)
Список 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 по дате отправления:

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