On Wed, Jun 20, 2007 at 12:55:23PM -0700, Steve Atkins wrote: > > Another approach, and one that can be more robust in the case > of external failures, is to have the trigger put the message it wants > to send into a queue table and have an external process that > monitors the table (via polling or listen/notify) and sends the > queued mail. For the record, this is _way_ more robust. It also prevents your database from accidentally DoSing your mail server, as it would if thousands of mail messages were all triggered in a very short period of time. A -- Andrew Sullivan | ajs@xxxxxxxxxxxxxxx The very definition of "news" is "something that hardly ever happens." --Bruce Schneier