Thread: 'dml' value for log_statement

'dml' value for log_statement

From
Sawada Masahiko
Date:
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

Re: 'dml' value for log_statement

From
David Johnston
Date:
Sawada Masahiko wrote
> 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

-1

I'm not fully versed on what log levels provide what data but if you care
about changes to data then "ALTER TABLE table" is just as important an
activity as "UPDATE table" so "mod" exhibits the recommended behavior and
"dml" provides something that should be of minimal value.

DML by itself has value since monitoring schema changes without worrying
about transient data updates is understandable.  But a schema-change, by
definition, alters data.

Maybe further description of why you find "mod" unsatisfactory would be
helpful.

Though it is simple enough to just let people use their own judgement....

David J.




--
View this message in context:
http://postgresql.1045698.n5.nabble.com/dml-value-for-log-statement-tp5790895p5790925.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.