Re: Enhancement proposal - detect chain of triggers from inside the trigger - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Enhancement proposal - detect chain of triggers from inside the trigger
Date
Msg-id CAFj8pRBa2_X0o0abLBprchEqHD-Eb_vSemLPNCBH7W-EyHqUxw@mail.gmail.com
Whole thread Raw
In response to Enhancement proposal - detect chain of triggers from inside the trigger  (Edson Richter <edsonrichter@hotmail.com>)
Responses Re: Enhancement proposal - detect chain of triggers from inside the trigger  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
2013/1/16 Edson Richter <edsonrichter@hotmail.com>:
> 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).

-1

building dynamic used array, that should or should not used can
significantly decrease performance :(

if you need it, you can use workaround - session variables.

Regards

Pavel Stehule

>
> Would help debug database triggers that have cascaded events.
>
> Regards,
>
> Edson
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general


pgsql-general by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: [pgpool-general: 1315] Re: Database connections seemingly hanging
Next
From: Stuart Bishop
Date:
Subject: Re: Linux Distribution Preferences?