Search Postgresql Archives

Re: untrusted languages and non-global superusers?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




--- 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux