Re: Event scheduling - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Event scheduling
Date
Msg-id CA+U5nMK3424j4CbGqA9ccM4FDKK+4k6Mrbk57Twgx1-8UOA6MQ@mail.gmail.com
Whole thread Raw
In response to Re: Event scheduling  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
On Mon, Apr 2, 2012 at 8:36 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
> On Mon, Apr 2, 2012 at 1:17 AM, Joe Van Dyk <joe@tanga.com> wrote:
>
>> Anyone else want event scheduling / cron / temporal triggers in
>> postgresql? http://dev.mysql.com/doc/refman/5.1/en/events-overview.html
>> shows how it works in mysql.
>>
>> Can we throw money at someone to get this in postgres? Is there work
>> already being done on this?
>>
>> Being able to regularly execute a postgres function every so often
>> would be really nice. It would simplify lots of deployments.
>
> I'm working on this. Glad to hear someone else wants this also.

When I say "working on this", I mean the ability to have a
user-defined daemon in Postgres, which is sufficient infrastructure to
provide the basis for a user space scheduler.

I'm not going anywhere near writing anything that looks like a scheduler.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


pgsql-hackers by date:

Previous
From: Daniel Farina
Date:
Subject: Re: HTTP Frontend? (and a brief thought on materialized views)
Next
From: Dave Page
Date:
Subject: Re: Switching to Homebrew as recommended Mac install?