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