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

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: triggers on prepare, commit, rollback... ?
Date: 2008-05-20 18:51:32
Message-ID: 20080520185132.GH27988@frubble.xen.chris-lamb.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Fetter 2008-05-20 21:11:10 Re: idea: storing view source in system catalogs
Previous Message Merlin Moncure 2008-05-20 18:03:17 idea: storing view source in system catalogs