transaction logging in the form of SQL statements
Is there any way to enable transaction logging in the format of SQL statements for committed transactions only ? In other words, a way to log all the SQL statements (including START TRANSACTION and COMMIT statements) for all committed mod type statements (INSERT UPDATE DELETE etc).
Thanks,
Omar
Use
log_min_duration_statement=0
at postgresql.conf file to log every statement.
On Tue, Jan 12, 2010 at 7:50 AM, Omar Mehmood <omarmehmood@yahoo.com> wrote:
Show quoted text
Is there any way to enable transaction logging in the format of SQL
statements for committed transactions only ? In other words, a way to log
all the SQL statements (including START TRANSACTION and COMMIT statements)
for all committed mod type statements (INSERT UPDATE DELETE etc).Thanks,
Omar--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
2010/1/12 Omar Mehmood <omarmehmood@yahoo.com>:
Is there any way to enable transaction logging in the format of SQL statements for committed transactions only ? In other words, a way to log all the SQL statements (including START TRANSACTION and COMMIT statements) for all committed mod type statements (INSERT UPDATE DELETE etc).
no, you can log only all SQL statements.
Regards
Pavel Stehule
Show quoted text
Thanks,
Omar--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general