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

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. Nothi

[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