Postgres Pro
Downloads
Home   >   mailing lists

Re: log_statement = 'mod' does not log all data modifying statements - Mailing list pgsql-general

From Bruce Momjian
Subject Re: log_statement = 'mod' does not log all data modifying statements
Date
Msg-id 20150909135908.GA7575@momjian.us
Whole thread Raw
In response to log_statement = 'mod' does not log all data modifying statements  (Jack Christensen <jack@jackchristensen.com>)
Responses Re: log_statement = 'mod' does not log all data modifying statements
List pgsql-general
Tree view 
On Fri, Jun 12, 2015 at 01:54:30PM -0500, Jack Christensen wrote:
> 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?

Not really.  Is this something we should document better?

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

  + Everyone has their own god. +

pgsql-general by date:

Previous
From: Sachin Srivastava
Date:
Subject: Re: pg_basebackup problem for Streaming replication
Next
From: Stephen Frost
Date:
Subject: Re: log_statement = 'mod' does not log all data modifying statements