Re: Enhancement proposal - detect chain of triggers from inside the trigger

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: Edson Richter <edsonrichter(at)hotmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Enhancement proposal - detect chain of triggers from inside the trigger
Date: 2013-01-15 23:36:12
Message-ID: 50F5E7EC.8000809@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 01/15/2013 03:30 PM, Edson Richter wrote:
> I was wondering, would be a nice addition the ability to read the chain
> of triggers (may be another trigger variable like TG_OP, called
> "TG_CHAIN" or something else that will be an array with the name of the
> triggers called before current trigger).

Well for a given table triggers run in alphabetical name order if that
helps.

>
> Would help debug database triggers that have cascaded events.
>
> Regards,
>
> Edson
>
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Edson Richter 2013-01-15 23:51:33 Re: Enhancement proposal - detect chain of triggers from inside the trigger
Previous Message Edson Richter 2013-01-15 23:30:20 Enhancement proposal - detect chain of triggers from inside the trigger