triggers and actions tree/2 - Mailing list pgsql-hackers

From Fabio Nanni
Subject triggers and actions tree/2
Date
Msg-id 3A3742FD.C789E3F7@albourne.com
Whole thread Raw
List pgsql-hackers
Hello all,
sorry, but I haven't received any replies to my previous message... and
it's important for me to solve it.

When I perform an action on a psql database (e.g. insert into a table),
some more action could be induced, via trigger firing: - is it possible to know at any time the exact action chain? -
isit possible to know at any time if the control is inside a
 
trigger (and which one)?
Sorry, I tried to search in www.postgresql.org  but I wasn't able to
find anything useful.

These questions arise because I'm trying to keep in sync two identical
psql databases; I have audited tables and an audit trail. I'm facing the
problem of recognising which actions in the trail were due to a trigger
firing, rather than explicitly commanded.

Thanks again
Fabio


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Bug in ILIKE function?
Next
From: Zeugswetter Andreas SB
Date:
Subject: AW: SourceForge & Postgres