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)
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]
---
> 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.
ets à la manipulation, nous ne 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: T
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 s
> > 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
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 Nabbl
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
http://www.depesz.com/2012/06/13/how-t
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
Check this article:
http://www.depesz.com/2012/06/13/how-to-send-mail-from-database/
2012/9/20 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?. [hidden
>
10 matches
Mail list logo
