Em Friday 15 February 2008 12:36:37 Adam Rich escreveu: > > I would instead queue messages (or suitable information about them) in > > a table, and have a process outside PostgreSQL periodically poll for them > > Why poll when you can wait? > > http://www.postgresql.org/docs/8.2/interactive/sql-notify.html To use cron and prevent system resources being allocated when not needed? To prevent one other external system to keep a connection open to the database? To guarantee that if the external system crashed somehow during one batch execution it would still keep sending emails when it was activated again? I can see notify being useful to GUI clients that need to update some information in near real time. Even for web applications it is easier to code a "poll" and a refresh using AJAX to prevent full screen redraws. I don't see LISTEN/NOTIFY as an useful tool for sending emails, though. -- Jorge Godoy <jgodoy@xxxxxxxxx> ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
