Re: Audit trail

Поиск
Список
Период
Сортировка
От Jeff Fitzmyers
Тема Re: Audit trail
Дата
Msg-id E2B31091-550A-11D7-9482-000A959C6000@cloverpub.com
обсуждение исходный текст
Ответ на Audit trail  (James Gregory <james@anchor.net.au>)
Ответы Re: Audit trail  (James Gregory <james@anchor.net.au>)
Список pgsql-general
> I am wondering if anyone has any good solutions for having postgres
> leave an audit trail.

I had 2 tables that needed a simple audit trail. It was very easy to
set up using php.

A few lines of code within transactions:
When a row is created, log it.
When any changes happen, log them, who did them and why.

I never felt I needed all the info for each row - just the changes.

Jeff


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

Предыдущее
От: Joshua Moore-Oliva
Дата:
Сообщение: Re: Audit trail
Следующее
От: James Gregory
Дата:
Сообщение: Re: Audit trail