Re: transaction logging in the form of SQL statements

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Omar Mehmood <omarmehmood(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: transaction logging in the form of SQL statements
Date: 2010-01-12 06:30:03
Message-ID: 162867791001112230w18d8ee5cnea8642f441fafb6c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2010/1/12 Omar Mehmood <omarmehmood(at)yahoo(dot)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

>
> Thanks,
> Omar
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2010-01-12 06:33:07 Re: Best Practice when Encounter Invalid Stored Procedure Parameters
Previous Message Scott Mead 2010-01-12 06:29:48 Re: location for pg_default tablespace