Re: avoiding endless loop in an UPDATE trigger

From: "Dominic J(dot) Eidson" <sauron(at)the-infinite(dot)org>
To: "Norman J(dot) Clarke" <norman(at)combimatrix(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: avoiding endless loop in an UPDATE trigger
Date: 2001-02-26 20:29:22
Message-ID: Pine.LNX.4.21.0102261428380.29312-100000@morannon.the-infinite.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tulio Oliveira 2001-02-26 21:09:58 Trigger sending an eMail
Previous Message Norman J. Clarke 2001-02-26 19:53:51 avoiding endless loop in an UPDATE trigger