Re: Want to schedule tasks for the future

On Wed, Jul 07, 2010 at 01:53:25PM +0000, Matthew Wilson wrote:
>     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.

You could have a trigger tell you when the first item to be delivered
changes.  I'd still be tempted to keep the waiting outside the database.

--
  Sam  http://samason.me.uk/