Skip site navigation (1) Skip section navigation (2)

triggers and actions tree

From: Fabio Nanni <f(dot)nanni(at)albourne(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: triggers and actions tree
Date: 2000-12-04 12:39:34
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Hello all,

I am new to postgreSQL.
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?
  - is it possible to know at any time if the control is inside a
trigger (and which one)?
Sorry, I tried to search in  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.

Thank you in advance

pgsql-hackers by date

Next:From: Jan WieckDate: 2000-12-04 12:52:50
Subject: Wrong FOR UPDATE lock type
Previous:From: Vince VielhaberDate: 2000-12-04 11:37:23
Subject: Re: beta testing version

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group