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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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. +
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2011-07-12 00:35:37 | Re: BUG #6082: server segfault - pg_stat_reset_shared(null) |
Previous Message | Emanuel Calvo | 2011-07-11 23:58:31 | application_name appears in Reporting and logging |