Postgres Pro
Downloads
Home   >   mailing lists

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

From Alvaro Herrera
Subject Re: rule creating infinite recursion not sure why
Date
Msg-id 20070216152927.GK13241@alvh.no-ip.org
Whole thread Raw
In response to rule creating infinite recursion not sure why  (Gene <genekhart@gmail.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: rule creating infinite recursion not sure why
Next
From: Erik Jones
Date:
Subject: Re: requests / suggestions to help with backups