Re: Timed Triggers? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Timed Triggers?
Date
Msg-id 7683.971130813@sss.pgh.pa.us
Whole thread Raw
In response to Timed Triggers?  (Rod Taylor <rod.taylor@inquent.com>)
List pgsql-hackers
Rod Taylor <rod.taylor@inquent.com> writes:
> With the number of cron jobs that run a perl script which runs a simple
> SELECT function(); that does various nightly cleanup or maintenance
> (billing run) it would be much nicer to have an actual trigger run every
> 12 hours rather than be initiated by a cron job.

Er ... why?  Seems like what you're describing is implementing the guts
of cron in the postmaster.  I don't see a real good reason to re-invent
the wheel like that.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "VARGA, Peter"
Date:
Subject:
Next
From: "Reimer, Fred"
Date:
Subject: ld.so error when inserting with a plpgsql trigger function