Re: Can we have time based triggers in Postgresql??

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Can we have time based triggers in Postgresql??
Date: 2004-04-07 14:12:26
Message-ID: 87n05nho6t.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Eric Ridge 2004-04-07 14:28:55 Re: Cursors and Transactions, why?
Previous Message Wes Palmer 2004-04-07 14:11:28 Re: Cursors and Transactions, why?