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

Tom Hodder wrote:
>
> 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.

log_statement only shows client-submitted queries, not function or
trigger queries.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +