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

2009-10-12 Thread Erik Jones
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.

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

2009-10-12 Thread Craig Ringer
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,

[GENERAL] Is there a way to know if trigger is invoked by the code from another trigger

2009-10-11 Thread Naoko Reeves
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