Postgres Pro
Downloads
Home   >   mailing lists

Re: transaction logging in the form of SQL statements - Mailing list pgsql-general

From AI Rumman
Subject Re: transaction logging in the form of SQL statements
Date
Msg-id 2a7905441001112026y337eda06yd96219ca0f0b7b4c@mail.gmail.com
Whole thread Raw
In response to transaction logging in the form of SQL statements  (Omar Mehmood <omarmehmood@yahoo.com>)
List pgsql-general
Tree view
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:
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

pgsql-general by date:

Previous
From: Omar Mehmood
Date:
Subject: transaction logging in the form of SQL statements
Next
From: Francisco Reyes
Date:
Subject: Re: Using a lock to avoid: could not open relation with OID