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

Re: BUG #6081: trigger CRUD log entries, or documentation not clear that triggers do not log

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Tom Hodder <tom(at)limepepper(dot)co(dot)uk>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6081: trigger CRUD log entries, or documentation not clear that triggers do not log
Date: 2011-07-12 00:28:43
Message-ID: 201107120028.p6C0Shk27161@momjian.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Tom Hodder wrote:
> 
> The following bug has been logged online:
> 
> Bug reference:      6081
> Logged by:          Tom Hodder
> Email address:      tom(at)limepepper(dot)co(dot)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(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

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

In response to

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2011-07-12 00:35:37
Subject: Re: BUG #6082: server segfault - pg_stat_reset_shared(null)
Previous:From: Emanuel CalvoDate: 2011-07-11 23:58:31
Subject: application_name appears in Reporting and logging

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