Re: [GENERAL] log_statement = 'mod' does not log all data modifying statements

2015-09-09 Thread Michael Paquier
On Wed, Sep 9, 2015 at 11:24 PM, Igor Neyman wrote: > Could you please provide reference to pg_audit? Should be here: http://pgaudit.org/ https://github.com/pgaudit/pgaudit -- Michael -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: ht

Re: [GENERAL] log_statement = 'mod' does not log all data modifying statements

2015-09-09 Thread Igor Neyman
= 'mod' does not log all data modifying statements * Bruce Momjian (br...@momjian.us) wrote: > 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

Re: [GENERAL] log_statement = 'mod' does not log all data modifying statements

2015-09-09 Thread Stephen Frost
* Bruce Momjian (br...@momjian.us) wrote: > 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 C

Re: [GENERAL] log_statement = 'mod' does not log all data modifying statements

2015-09-09 Thread Bruce Momjian
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

[GENERAL] log_statement = 'mod' does not log all data modifying statements

2015-06-12 Thread Jack Christensen
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 -- Sent via pgsql-general mailing list (pgsql-gene