'dml' value for log_statement - Mailing list pgsql-hackers

From Sawada Masahiko
Subject 'dml' value for log_statement
Date
Msg-id CAD21AoCUz5oNh2T53_9AbfefVgVs+4Fa0+yHxACQ+tRSjMMgyA@mail.gmail.com
Whole thread Raw
Responses Re: 'dml' value for log_statement  (David Johnston <polobo@yahoo.com>)
List 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

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Add CREATE support to event triggers
Next
From: Jeff Janes
Date:
Subject: Re: Minor performance improvement in transition to external sort