Re: avoiding endless loop in an UPDATE trigger

On Mon, 26 Feb 2001, Norman J. Clarke wrote:

> The problem with this is that it disables all of my FOREIGN KEY
> constraints during function execution, which is undesirable.

Foreign Key constraints are implemented as triggers, IIRC. I'll let you
figure out the implication(s) yourself.


--
Dominic J. Eidson
                                        "Baruk Khazad! Khazad ai-menu!" - Gimli
-------------------------------------------------------------------------------
http://www.the-infinite.org/              http://www.the-infinite.org/~dominic/