Postgres Pro
Downloads
Home   >   mailing lists

Re: Need help creating a BEFORE DELETE trigger - Mailing list pgsql-sql

From Rod Taylor
Subject Re: Need help creating a BEFORE DELETE trigger
Date
Msg-id 1057020087.28657.106.camel@jester
Whole thread Raw
In response to Need help creating a BEFORE DELETE trigger  (Michael A Nachbaur <mike@nachbaur.com>)
List pgsql-sql
Tree view 
> 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@rbt.ca>

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

pgsql-sql by date:

Previous
From: Rod Taylor
Date:
Subject: Re: cleaning up useless pl/pgsql functions
Next
From: Erik Erkelens
Date:
Subject: CREATE SEQUENCE fails in plpgsql function