Postgres Pro
Downloads
Home   >   mailing lists

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

From Edson Richter
Subject Enhancement proposal - detect chain of triggers from inside the trigger
Date
Msg-id BLU0-SMTP4154E8A2E90F6EFDAD4DB6BCF2D0@phx.gbl
Whole thread Raw
Responses Re: Enhancement proposal - detect chain of triggers from inside the trigger  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: Enhancement proposal - detect chain of triggers from inside the trigger  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Tree view 
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).

Would help debug database triggers that have cascaded events.

Regards,

Edson

pgsql-general by date:

Previous
From: Venky Kandaswamy
Date:
Subject: Re: [SQL] Curious problem of using BETWEEN with start and end being the same versus EQUALS '='
Next
From: Adrian Klaver
Date:
Subject: Re: Enhancement proposal - detect chain of triggers from inside the trigger