Re: rule creating infinite recursion not sure why

Поиск
Список
Период
Сортировка
Искать
От
Alvaro Herrera
Тема
Re: rule creating infinite recursion not sure why
Дата
Msg-id
20070216152927.GK13241@alvh.no-ip.org
Ответ на
rule creating infinite recursion not sure why (Gene)
Список
Дерево обсуждения
rule creating infinite recursion not sure why Gene <genekhart@gmail.com>
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>
Re: rule creating infinite recursion not sure why Tom Lane <tgl@sss.pgh.pa.us> 
Gene wrote:
> I was trying to create a rule to set a column to false whenever another
> column was changed:

Don't.  Use a BEFORE trigger, and instead of issuing a new UPDATE, just
change the NEW record that you return.  It's conceptually much simpler.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
В списке pgsql-general по дате отправления
Предыдущее
От: Andreas Kretschmer
Дата:
Следующее
От: Erik Jones
Дата:
FAQ