Re: Scheduled jobs - Mailing list pgsql-hackers

From Christopher Browne
Subject Re: Scheduled jobs
Date
Msg-id m3ptmnn3px.fsf@chvatal.cbbrowne.com
Whole thread Raw
In response to Re: Scheduled jobs  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
Responses Re: Scheduled jobs
List pgsql-hackers
Quoth nandrews@investsystems.co.uk ("Nigel J. Andrews"):
> I believe this has arisen several times and each time there's been
> no enthusiasm to stick cron into the core which I think is a
> reasonable stance.

I think it _would_ be kind of neat to set up some tables to contain
what's in the postgres user's crontab, and have a pair of stored
procedures to move data in and out.  If you had some Truly Appalling
number of cron jobs, manipulating them in a database could well be a
great way to do it.

That is, of course, quite separate from having cron in the core.  And
having a _good_ set of semantics for the push/pull is a nontrivial
matter...
-- 
If this was helpful, <http://svcs.affero.net/rm.php?r=cbbrowne> rate me
http://cbbrowne.com/info/nonrdbms.html
As Will Rogers would have said, "There is no such thing as a free
variable."  -- Alan Perlis



pgsql-hackers by date:

Previous
From: alex avriette
Date:
Subject: Re: patch src/bin/psql/help.c
Next
From: Alvaro Herrera
Date:
Subject: Re: [PATCHES] Static snapshot data