[GENERAL] Need psql send email

2012-09-20 Thread pavithra
Hi All,I am new to postgresql. I want to send email by using pl pgsql. I want to know how to set up the configurations for mail server.Can any one help me in solving this?. pavithra@gmail.com -- View this message in context:

Re: [GENERAL] Need psql send email

2012-09-20 Thread Victor Yegorov
Check this article: http://www.depesz.com/2012/06/13/how-to-send-mail-from-database/ 2012/9/20 pavithra pavithra@gmail.com Hi All, I am new to postgresql. I want to send email by using pl pgsql. I want to know how to set up the configurations for mail server. Can any one help me in

Re: [GENERAL] Need psql send email

2012-09-20 Thread Raymond O'Donnell
On 20/09/2012 13:07, pavithra wrote: Hi All, I am new to postgresql. I want to send email by using pl pgsql. I want to know how to set up the configurations for mail server. Can any one help me in solving this?. [hidden email] Hi there, It's not possible to send email directly from pl/pgsql;

Re: [GENERAL] Need psql send email

2012-09-20 Thread hubert depesz lubaczewski
On Thu, Sep 20, 2012 at 05:07:18AM -0700, pavithra wrote: Hi All,I am new to postgresql. I want to send email by using pl pgsql. I want to know how to set up the configurations for mail server.Can any one help me in solving this?. pavithra@gmail.com

Re: [GENERAL] Need psql send email

2012-09-20 Thread pavithra
I am more wondered where we need to give the port address and smtpserver. Can you give me the details of these?. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Need-psql-send-email-tp5724700p5724705.html Sent from the PostgreSQL - general mailing list archive at

Re: [GENERAL] Need psql send email

2012-09-20 Thread Martin French
Hi All,I am new to postgresql. I want to send email by using pl pgsql. I want to know how to set up the configurations for mail server.Can any one help me in solving this?. pavithra@gmail.com http://www.depesz.com/2012/06/13/how-to-send-mail-from-database/ Best regards,

Re: [GENERAL] Need psql send email

2012-09-20 Thread Craig Ringer
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

Re: [GENERAL] Need psql send email

2012-09-20 Thread Martin Gainty
pouvons accepter aucune responsabilité pour le contenu fourni. To: dep...@depesz.com CC: pavithra@gmail.com; pgsql-general@postgresql.org; pgsql-general-ow...@postgresql.org Subject: Re: [GENERAL] Need psql send email From: martin.fre...@romaxtech.com Date: Thu, 20 Sep 2012 13:40:58 +0100

Re: [GENERAL] Need psql send email

2012-09-20 Thread Martin French
The 1st one seems OK in a scary-from-a-security-standpoint kind of way. Agree, it needs to be weighed up and assessed from a security stand point I guess. The 2nd, not so much. See http://stackoverflow.com/questions/12002662/psql-trigger-send-email Imagine if the DNS goes wonky. Do

Re: [GENERAL] Need psql send email

2012-09-20 Thread Edson Richter
Em 20/09/2012 09:07, pavithra escreveu: Hi All, I am new to postgresql. I want to send email by using pl pgsql. I want to know how to set up the configurations for mail server. Can any one help me in solving this?. [hidden email] /user/SendEmail.jtp?type=nodenode=5724700i=0

Re: [GENERAL] Need psql send email

2012-09-20 Thread Chris Travers
Hi all; A couple points here. First, you probably don't want to send email directly from a database function. This gives significant problems for which there is no good solution. Consider: 1) You sent your email and now the transaction rolls back. You *cannot* roll back the sent email. 2)