Extract transaction logging

Поиск
Список
Период
Сортировка
От W. van den Akker
Тема Extract transaction logging
Дата
Msg-id 4024BE0C.9050409@wilsoft.nl
обсуждение исходный текст
Ответ на SHOW TABLES ?  (pgmoscatt <pgmoscatt@optushome.com.au>)
Ответы Re: Extract transaction logging  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-general
Hi,

Is it somehow possible to extract the transaction logging?
Once a day I want to get a report with:
- the insert,delete,update transactions;
- who (user) did the transaction;
- time and date of the transaction;

Secondly, how can I determine which user is locking a record?
Sometimes a user left his dialogbox open on an update transaction.
I want users who also wants to update that record, get a message
"record locked by .....(user)"

And last...
How can I present the errormessages in 'Dutch' to the users.


TIA

Willem


В списке pgsql-general по дате отправления:

Предыдущее
От: Paul Thomas
Дата:
Сообщение: Re: SHOW TABLES ?
Следующее
От: Paul Thomas
Дата:
Сообщение: Re: Can anyone recommend accounting software using PGSQL?