| From: | Craig Ringer <ringerc(at)ringerc(dot)id(dot)au> |
|---|---|
| To: | Martin French <Martin(dot)French(at)romaxtech(dot)com> |
| Cc: | depesz(at)depesz(dot)com, pavithra <pavithra(dot)ibt(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-general-owner(at)postgresql(dot)org |
| Subject: | Re: Need psql send email |
| Date: | 2012-09-20 12:57:49 |
| Message-ID: | 505B12CD.9040606@ringerc.id.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martin Gainty | 2012-09-20 13:00:46 | Re: Need psql send email |
| Previous Message | David Johnston | 2012-09-20 12:45:11 | Re: RFE: Column aliases in WHERE clauses |