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

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.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD