Invocation recognition.

From: Marek PUBLICEWICZ <M(dot)Publicewicz(at)elka(dot)pw(dot)edu(dot)pl>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Invocation recognition.
Date: 2001-07-14 14:40:10
Message-ID: Pine.SOL.4.30.0107141632370.5392-100000@elektron.elka.pw.edu.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I wonder if it would be possible inside a trigger fired
BEFORE UPDATE to detect, whether the action (UPDATE), which
activated the trigger was invoked from inside another trigger.
Is it possible to distinguish invocation from the other trigger from
the direct invocation made by the user 'by hand'? I need it in order to
determine in the BEFORE UPDATE trigger, whether to allow to perform the
update.
The triggers are written in C, if this matters.

any help appreciated ;)
mark

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Lockhart 2001-07-14 15:16:42 Re: Nusphere/MySQL-AB arguing
Previous Message Bruce Momjian 2001-07-14 14:27:50 Re: Nusphere/MySQL-AB arguing