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