Re: Need psql send email

On 09/20/2012 08:40 PM, Martin French wrote:
>
> Both of these work fine provided PL/PerlU is installed and the server is
> properly configured on the network, and that there is a valid SMTP mail
> host to receive.

The 1st one seems OK in a scary-from-a-security-standpoint kind of way.

The 2nd, not so much. See
   http://stackoverflow.com/questions/12002662/psql-trigger-send-email

Imagine if the DNS goes wonky. Do you want all your backends tied up in
DNS lookups? Or timing-out TCP connections?

BTW, pavithra, check out http://brandolabs.com/pgmail if you really want
to do it in the database.

--
Craig Ringer