Timed Triggers?

From: Rod Taylor <rod(dot)taylor(at)inquent(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Timed Triggers?
Date: 2000-10-02 13:26:23
Message-ID: 39D88CFF.884F8664@inquent.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

This may seem a little silly, but I'd like to request a feature to
implement timed triggers.

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.

Less places things could go wrong. Could be requested to run only when
a table isn't being used at the time (low priority maintenance). The
same thing could be implemented for a periodic vacuum.

I'd like to take this up myself, but will need to learn alot about the
way Postgres works first so if someone else sees the need as well please
feel free to implement (It'll take me atleast 6 months before I feel
comfortable with the results).

--
Rod Taylor
--

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Louis-David Mitterrand 2000-10-02 14:03:04 failed assertion error on PG-7.0.2
Previous Message Hannu Krosing 2000-10-02 11:45:35 Re: backup and restore