Thread: Is there a way to know if trigger is invoked by the code from another trigger
Is there a way to know if trigger is invoked by the code from another trigger
From
"Naoko Reeves"
Date:
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.
Thank you,
Naoko
Re: Is there a way to know if trigger is invoked by the code from another trigger
From
Erik Jones
Date:
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. Erik Jones, Database Administrator Engine Yard Support, Scalability, Reliability 866.518.9273 x 260 Location: US/Pacific IRC: mage2k
Re: Is there a way to know if trigger is invoked by the code from another trigger
From
Craig Ringer
Date:
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