Postgres Pro
Downloads
Home   >   mailing lists

Re: avoiding endless loop in an UPDATE trigger - Mailing list pgsql-general

From Dominic J. Eidson
Subject Re: avoiding endless loop in an UPDATE trigger
Date
Msg-id Pine.LNX.4.21.0102261428380.29312-100000@morannon.the-infinite.org
Whole thread Raw
In response to avoiding endless loop in an UPDATE trigger  ("Norman J. Clarke" <norman@combimatrix.com>)
Responses Re: avoiding endless loop in an UPDATE trigger  ("Norman J. Clarke" <norman@combimatrix.com>)
List pgsql-general
Tree view 
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/

pgsql-general by date:

Previous
From: "Norman J. Clarke"
Date:
Subject: avoiding endless loop in an UPDATE trigger
Next
From: Tulio Oliveira
Date:
Subject: Trigger sending an eMail