Re: Need help creating a BEFORE DELETE trigger

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Michael A Nachbaur <mike(at)nachbaur(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Need help creating a BEFORE DELETE trigger
Date: 2003-07-01 00:41:28
Message-ID: 1057020087.28657.106.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> The problem I'm looking at is: could this cause a recursion problem, where the
> cascading deletion will try to cause the whole thing to cascade again? How

It will only be able to delete the row (and cascade) once per row. The
second time it tries to find the row, the row won't exist anymore.
--
Rod Taylor <rbt(at)rbt(dot)ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2003-07-01 03:32:23 Re: LEAST and GREATEST functions?
Previous Message Rod Taylor 2003-07-01 00:39:06 Re: cleaning up useless pl/pgsql functions