From: Richard Huxton <dev@archonet.com>
To: wit <microx@hotpop.com>
To: pgsql-sql@postgresql.org
Subject: Re: check source of trigger
Date: Fri, 20 Sep 2002 10:23:43 +0100
Message-ID: <200209201023.43571.dev@archonet.com> (raw)
In-Reply-To: <amem61$1j4o$1@news.hub.org>
References: <amem61$1j4o$1@news.hub.org>
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_codeA
> 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
procedure (not just OLD and NEW) - is that what you were after (Programmers
manual, ch 23.9)
- Richard Huxton
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, microx@hotpop.com
Subject: Re: check source of trigger
In-Reply-To: <200209201023.43571.dev@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox