Want to schedule tasks for the future

From: Matthew Wilson <matt(at)tplus1(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Want to schedule tasks for the future
Date: 2010-07-07 13:53:25
Message-ID: i120sk$u8n$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Just recently I discovered the listen/notify feature in postgresql.
Now I don't have external processes polling tables, watching for new
inserted rows.

Anyhow, I'm curious if there is some other feature that will help me out
with a new puzzle.

I want to store emails to deliver at a later time in my database. For
example, I want to remember that tomorrow morning at 9:00 am, I want to
send a particular email.

I'll use a table sort of like this

create table scheduled_email (
to_address text,
email_subject text,
email_body text,
deliver_at timestamp,
sent boolean
);

I know I could write an external process to poll this table and select
all rows where deliver_at < current_timestamp and sent = 'f'.

But is there some other way inside postgresql that will do something
similar? I would want something like listen/notify, where postgres
starts an external process when any data exist.

Thanks for the help.

Matt

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Colson 2010-07-07 13:56:42 Re: make view with union return one record
Previous Message Johan Andersson 2010-07-07 13:48:33 Trigger for modification timestamp column