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 <genekhart@gmail.com>)
Список pgsql-general
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
Дата:
Сообщение: Re: rule creating infinite recursion not sure why
Следующее
От: Erik Jones
Дата:
Сообщение: Re: requests / suggestions to help with backups