Gordon wrote:
So what I want to know is, is there a way to tell if executing a query caused a trigger to fire? I don't need anything fancy like notify and listen, I just want to see what the database is doing for testing purposes. For example by looking at the logs and seeing what activity was caused by a given query. Does this stuff get logged?
If you can modify the trigger and it's written in PL/PgSQL you can use a `RAISE NOTICE' statement to log some information when the trigger fires. Those are several big "if"s though.
-- Craig Ringer
