Re: transaction logging in the form of SQL statements

Поиск
Список
Период
Сортировка
От AI Rumman
Тема Re: transaction logging in the form of SQL statements
Дата
Msg-id 2a7905441001112026y337eda06yd96219ca0f0b7b4c@mail.gmail.com
обсуждение исходный текст
Ответ на transaction logging in the form of SQL statements  (Omar Mehmood <omarmehmood@yahoo.com>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Omar Mehmood
Дата:
Сообщение: transaction logging in the form of SQL statements
Следующее
От: Francisco Reyes
Дата:
Сообщение: Re: Using a lock to avoid: could not open relation with OID