log_statement = 'mod' does not log all data modifying statements

From: Jack Christensen <jack(at)jackchristensen(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: log_statement = 'mod' does not log all data modifying statements
Date: 2015-06-12 18:54:30
Message-ID: 557B2AE6.9010602@jackchristensen.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I was recently surprised by changes that were not logged by
log_statement = 'mod'. After changing log_statement to 'all', I found
that the changes were occurring in a writable CTE.

Is there a way to log all statements that update data?

Jack

Responses

Browse pgsql-general by date

  From Date Subject
Next Message greg 2015-06-12 18:57:46 Re: double precision[] storage space questions
Previous Message Sheena, Prabhjot 2015-06-12 17:57:22 pg bouncer issue what does sv_used column means