Re: [GENERAL] Cascading Trigger Prevention

2007-12-02 Thread JonXP
On Nov 29, 5:09 pm, [EMAIL PROTECTED] (Martijn van Oosterhout) wrote: On Wed, Nov 28, 2007 at 02:00:58PM -0800, JonXP wrote: I have a table that contains a nested set (using paths), and I'm trying to create a trigger that updates the timestamps of a node and all of its parents on a

[GENERAL] Cascading Trigger Prevention

2007-11-29 Thread JonXP
Hello All, I have a table that contains a nested set (using paths), and I'm trying to create a trigger that updates the timestamps of a node and all of its parents on a modification. Unfortunately, this is causing infinitely recurring triggers. The insert occurs, which fires the trigger, which

Re: [GENERAL] Cascading Trigger Prevention

2007-11-29 Thread Martijn van Oosterhout
On Wed, Nov 28, 2007 at 02:00:58PM -0800, JonXP wrote: I have a table that contains a nested set (using paths), and I'm trying to create a trigger that updates the timestamps of a node and all of its parents on a modification. Unfortunately, this is causing infinitely recurring triggers.