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

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Erik Jones <ejones(at)engineyard(dot)com>
Cc: Naoko Reeves <naoko(at)lawlogix(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Is there a way to know if trigger is invoked by the code from another trigger
Date: 2009-10-13 02:32:53
Message-ID: 1255401173.4702.2.camel@wallace.localnet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2009-10-13 03:03:03 Re: How useful is the money datatype?
Previous Message 纪晓曦 2009-10-13 02:19:36 Re: Where can I get the number of plans that considered by Planner?