--- Tino Wildenhain <tino@xxxxxxxxxxxxx> wrote: > > > > (The function uses mail(), so IIRC that > > > necessitates > > > > using plphpu). > > > > > > Sending mail from a database function (or doing > > > anything else that > > > involves external side-effects) is generally A > Bad > > > Idea, for reasons > > > that have been covered many times in the list > > > archives. > > > > Why, exactly? In this situation I just set up a > > trigger that sends a welcome email to newly > inserted > > members. Very convenient. > > Why cant your application handle this? > Otoh, why dont you provide a function to send mail, > which takes some parameters and just let your users > use them? No need for everybody to write her own > mail function. Convenience! I want the email sent whether the member is added via the web interface, directly in the database, from the command line, etc. I don't see any downside. It's only one user that'll be using this function. CSN __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match