m...@tplus1.com (Matthew Wilson) writes:
> 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.
>
Matthew Wilson schrieb:
> Just recently I discovered the listen/notify feature in postgresql.
> Now I don't have external processes polling tables, watching for new
> inserted rows.
>
You could try
http://www.pogo.org.uk/~mark/pgnotifyd/
Just found it, not tested until now.
Bernhard
--
Sent
On Wed, Jul 7, 2010 at 9:53 AM, Matthew Wilson wrote:
> 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.
>
No, there is no facility to do this within the dat
On Wed, Jul 07, 2010 at 01:53:25PM +, 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 p
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
