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

From Sam Mason
Subject Re: triggers on prepare, commit, rollback... ?
Date
Msg-id 20080520185132.GH27988@frubble.xen.chris-lamb.co.uk
Whole thread Raw
In response to Re: triggers on prepare, commit, rollback... ?  (Greg Smith <gsmith@gregsmith.com>)
Responses Re: triggers on prepare, commit, rollback... ?  (Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>)
List pgsql-hackers
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.

 Sam


pgsql-hackers by date:

Previous
From: "Merlin Moncure"
Date:
Subject: idea: storing view source in system catalogs
Next
From: David Fetter
Date:
Subject: Re: idea: storing view source in system catalogs