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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
