Content-Type: text/plain;
  charset="iso-8859-1"
From: Richard Huxton <dev@archonet.com>
Organization: Archonet Ltd
To: "wit" <microx@hotpop.com>, pgsql-sql@postgresql.org
Subject: Re: check source of trigger
Date: Fri, 20 Sep 2002 10:23:43 +0100
User-Agent: KMail/1.4.1
References: <amem61$1j4o$1@news.hub.org>
In-Reply-To: <amem61$1j4o$1@news.hub.org>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200209201023.43571.dev@archonet.com>

On Friday 20 Sep 2002 9:25 am, wit wrote:

> I have trigger and procedure on table B to capture any change and insert
> into table logB:
>     create trigger trigger_b before insert or update or delete on B for
> each row execute procedure log_change();
>
> When I update e_codeA in table A, the constrain trigger will update e_cod=
eA
> in B. My trigger, trigger_b, also was trigged and procedure will record
> change into table logB too.
> How to write a code in my db procedure to check whether the procedure was
> called by normal SQL or was called by cascade trigger.

There are a number of "special" variables defined if you are a trigger=20
procedure (not just OLD and NEW) - is that what you were after (Programmers=
=20
manual, ch 23.9)

- Richard Huxton