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

From Greg Smith
Subject Re: triggers on prepare, commit, rollback... ?
Date
Msg-id Pine.GSO.4.64.0805201317210.11969@westnet.com
Whole thread Raw
In response to Re: triggers on prepare, commit, rollback... ?  (Hannu Krosing <hannu@krosing.net>)
Responses Re: triggers on prepare, commit, rollback... ?  (Sam Mason <sam@samason.me.uk>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: Re: Installation of Postgres 32Bit on 64 bit machine
Next
From: "Merlin Moncure"
Date:
Subject: idea: storing view source in system catalogs