Re: triggers on prepare, commit, rollback... ?

On Tue, 20 May 2008 19:51:32 +0100 Sam Mason wrote:

> On Tue, May 20, 2008 at 01:20:48PM -0400, Greg Smith wrote:
> > On Tue, 20 May 2008, Hannu Krosing wrote:
> > 
> > >Tell others that this trx failed, maybe log a failure ? OTOH, this can 
> > >be implemented by a daemon that sits on "tail -f logfile | grep 
> > >ROLLBACK"
> > 
> > In order to follow the log files like that successfully in many 
> > environments, you need to stay in sync as the underlying log file changes 
> > (it might rotate every day for example).  Unfortunately it's not as simple 
> > as just using tail.
> 
> GNU tail provides the -F (or --follow=name) for just this reason.

Not every system is GNU.
Not every possible configuration uses the same logfile name for the
next logfile.


Kind regards

--             Andreas 'ads' Scherbaum
German PostgreSQL User Group