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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
