Postgres Pro
Downloads
Home   >   mailing lists

BUG #6081: trigger CRUD log entries, or documentation not clear that triggers do not log - Mailing list pgsql-bugs

From Tom Hodder
Subject BUG #6081: trigger CRUD log entries, or documentation not clear that triggers do not log
Date
Msg-id 201106290656.p5T6ueLN081668@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #6081: trigger CRUD log entries, or documentation not clear that triggers do not log
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      6081
Logged by:          Tom Hodder
Email address:      tom@limepepper.co.uk
PostgreSQL version: 8.4
Operating system:   Fedora 14 x86_64
Description:        trigger CRUD log entries, or documentation not clear
that triggers do not log
Details:

with this log directive set;
log_statement = 'mod'

I would expect that all CRUD statements would be logged to log_filename.
However CRUD statements called from trigger functions are not logged.

This is unexpected, and does not reflect my reading of the documentation.

pgsql-bugs by date:

Previous
From: "Chris Bandy"
Date:
Subject: BUG #6080: information_schema.columns.column_default contains NULL inconsistently
Next
From: Matthijs Bomhoff
Date:
Subject: Bug with plpgsql, temp tables and TOAST?