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 mo
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.
>
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 t