'dml' value for log_statement

From: Sawada Masahiko <sawada(dot)mshk(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: 'dml' value for log_statement
Date: 2014-02-06 18:20:53
Message-ID: CAD21AoCUz5oNh2T53_9AbfefVgVs+4Fa0+yHxACQ+tRSjMMgyA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,

Attaching patch provides new value 'dml' for log_statement.
Currently, The server logs modification statements AND data definition
statements if log_statement is set 'mod'.
So we need to set the 'all' value for log_statement and remove
unnecessary information
if we would like to log only DML.

This patch allows the user to set in detail the setting.
The server logs statement only when INSERT. UPDATE, DELETE and TRUNCATE
statement are executed.
( same as 'mod' value which does not log the DDL)

Comments?

Regards,

-------
Sawada Masahiko

Attachment Content-Type Size
log_statement_dml.patch application/octet-stream 2.9 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Janes 2014-02-06 18:21:16 Re: Minor performance improvement in transition to external sort
Previous Message Alvaro Herrera 2014-02-06 17:20:05 Re: Add CREATE support to event triggers