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