Re: [HACKERS] Event scheduling

2012-04-02 Thread Simon Riggs
On Mon, Apr 2, 2012 at 1:17 AM, Joe Van Dyk j...@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.

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

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Re: [HACKERS] Event scheduling

2012-04-02 Thread Simon Riggs
On Mon, Apr 2, 2012 at 8:36 AM, Simon Riggs si...@2ndquadrant.com wrote:
 On Mon, Apr 2, 2012 at 1:17 AM, Joe Van Dyk j...@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

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


[HACKERS] Event scheduling

2012-04-01 Thread Joe Van Dyk
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.

Thanks,
Joe

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers