Extract transaction logging

From: "W(dot) van den Akker" <listsrv(at)wilsoft(dot)nl>
To: PostGreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: Extract transaction logging
Date: 2004-02-07 10:29:32
Message-ID: 4024BE0C.9050409@wilsoft.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Thomas 2004-02-07 10:45:14 Re: Can anyone recommend accounting software using PGSQL?
Previous Message Paul Thomas 2004-02-07 09:40:22 Re: SHOW TABLES ?