Re: triggers on prepare, commit, rollback... ? - Mailing list pgsql-hackers

From Andreas 'ads' Scherbaum
Subject Re: triggers on prepare, commit, rollback... ?
Date
Msg-id 20080522021850.6dc93b98@iridium.wars-nicht.de
Whole thread Raw
In response to Re: triggers on prepare, commit, rollback... ?  (Sam Mason <sam@samason.me.uk>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: May Commitfest is done!
Next
From: "Robert Haas"
Date:
Subject: Re: idea: storing view source in system catalogs