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

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: Hannu Krosing <hannu(at)krosing(dot)net>
Cc: PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: triggers on prepare, commit, rollback... ?
Date: 2008-05-20 17:20:48
Message-ID: Pine.GSO.4.64.0805201317210.11969@westnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Merlin Moncure 2008-05-20 17:29:55 Re: libpq object hooks (libpq events)
Previous Message Devrim GÜNDÜZ 2008-05-20 14:35:19 Re: Installation of Postgres 32Bit on 64 bit machine