Re: Auditing idea

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: Auditing idea
Дата
Msg-id Pine.LNX.4.33.0308081040100.21258-100000@css120.ihs.com
обсуждение исходный текст
Ответ на Re: Auditing idea  (Mike Benoit <mikeb@netnation.com>)
Список pgsql-general
I think it's the SPI package from Hans...

On Fri, 8 Aug 2003, Mike Benoit wrote:

> You might want to take a look at this project:
> http://gborg.postgresql.org/project/tablelog/download/download.php
>
> There is another project similar to that one on gborg as well, but I
> don't recall the name at this time.
>
> On Thu, 2003-08-07 at 15:30, Felipe Schnack wrote:
> >   Hey all! I had an idea to implement a very simple (IMHO) auditing mechanism for an application I'm developing,
andthought some people here could give some hints, opinions, etc about it. 
> >   I was thinking about implementing update and delete triggers for all my tables that I want to be audited, and
thesetriggers would create automatically the auditing message for me. Basically, the update triggers would store the
rowvalues in the OLD and NEW rows, and the delete trigger would store the values in the OLD row. 
> >   What you guys think of this idea? To me seems simple and good enough.
> >
> >
> >  /~\ The ASCII        Felipe Schnack (felipes@ritterdosreis.br)
> >  \ / Ribbon Campaign  Analista de Sistemas
> >   X  Against HTML     Cel.: 51-91287530
> >  / \ Email!           Linux Counter #281893
> >
> > Centro Universitário Ritter dos Reis
> > http://www.ritterdosreis.br
> > ritter@ritterdosreis.br
> > Fone: 51-32303341
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> >                http://archives.postgresql.org
>


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

Предыдущее
От: "Eric Anderson Vianet SAO"
Дата:
Сообщение: Re: unexpected chunk number
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: FATAL: The database system is in recovery mode