Re: Is there a way to know if trigger is invoked by the code from another trigger

On Mon, 2009-10-12 at 10:36 -0700, Erik Jones wrote:
> On Oct 11, 2009, at 10:51 AM, Naoko Reeves wrote:
>
> > Could you tell me if there is a way to know if trigger is invoked by
> > the code from another trigger?
> > For instance, table A Trigger deletes table B record. While in table
> > B trigger, I want to know whether this was triggered from table A.
>
> Nothing built in to show you that.  You could, however, have your
> trigger on table A make an insert or update to a record in some table
> that the trigger on table B could then look for.

This is one of those places where transaction-scoped variables would be
really, really nice; a temp table is a bit of a clumsy way to do things.

--
Craig Ringer