Function to detect trigger recursion - Mailing list pgsql-general

From Vincent Roberts
Subject Function to detect trigger recursion
Date
Msg-id 3B028E5D.A8C46985@fccc.edu
Whole thread Raw
In response to 7.1-1 installation from RPM  ("Mihai Gheorghiu" <tanethq@earthlink.net>)
List pgsql-general
Hello:

Is there a builtin mechanism for detecting trigger recursion or more
specifically
one trigger , causing another tables trigger to fire.

Example:

Table A is updated

Table A's update trigger executes
{
    Updates the B table - (maintaining special RI etc.)
    Table B's update trigger executes
     {
           <does some stuff>
           <need to know if I was triggered from within another trigger> ?????
( Is there a function that does this? )
           <does some more stuff>
      }
}

Attachment

pgsql-general by date:

Previous
From: Alexander Dederer
Date:
Subject: Parallel Serever use PostgreSQL
Next
From: "Gregory Wood"
Date:
Subject: Re: set transaction question