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

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. +