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 |
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 |