Re: Can we have time based triggers in Postgresql?? - Mailing list pgsql-general

From Greg Stark
Subject Re: Can we have time based triggers in Postgresql??
Date
Msg-id 87n05nho6t.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: Can we have time based triggers in Postgresql??  (David Garamond <lists@zara.6.isreserved.com>)
Responses Re: Can we have time based triggers in Postgresql??
List pgsql-general
David Garamond <lists@zara.6.isreserved.com> writes:

> In short, it would be nice if we have a scheduling system where one can run
> queries or in-process procedures/functions instead of external commands. Also
> where one can use normal SQL/psql commands to manipulate the jobs; cron
> entries aren't exactly "programmable" or "structured" (e.g. how do you easily
> find entries that runs at least once every 10 min or more often?)

There's no reason you couldn't write a cron daemon that retrieved its list of
jobs from an SQL database. In fact we discussed doing exactly this at my last
job. I expect others have thought of the same idea and wouldn't be surprised
if it existed by now.

--
greg

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Can we have time based triggers in Postgresql??
Next
From: Eric Ridge
Date:
Subject: Re: Cursors and Transactions, why?