Thread: Triggers

Triggers

From
beyaRecords - The home Urban music
Date:
Hi,
does postgresql support the ability to email as in SQL Server? I want 
to create a trigger which on input of a record will send out an email. 
Is this possible?

Uzo



Re: Triggers

From
Peter Eisentraut
Date:
beyaRecords - The home Urban music wrote:
> does postgresql support the ability to email as in SQL Server? I want
> to create a trigger which on input of a record will send out an
> email. Is this possible?

Write a trigger function in, say, PL/PerlU or PL/sh and have it send the 
email with the usual Perl or shell commands.



Re: Triggers

From
Sai Hertz And Control Systems
Date:
Dear Uzo  ,

> Hi,
> does postgresql support the ability to email as in SQL Server? I want 
> to create a trigger which on input of a record will send out an email. 
> Is this possible?

http://pgmail.sourceforge.net/ is what you need.

Regards,

Vishal Kashyap



Re: Triggers

From
Richard Huxton
Date:
On Monday 12 January 2004 16:14, beyaRecords - The home Urban music wrote:
> Hi,
> does postgresql support the ability to email as in SQL Server? I want
> to create a trigger which on input of a record will send out an email.
> Is this possible?

Have a look in the mailing list archives - this has been covered recently. I 
seem to recall there is an add-on that does just this.

--  Richard Huxton Archonet Ltd


Re: Triggers

From
BenLaKnet
Date:
<br /><div class="moz-text-flowed" lang="x-western" style="font-family: -moz-fixed; font-size: 12px;">I try pgmail and
thatis well running ... <br /> fo security, do not use attachment files with your mail ... <br /><br /> try pgmail, you
needto use pl/tclu ... <br /><br /> Ben</div><br /><br /> Sai Hertz And Control Systems wrote:<br /><blockquote
cite="mid4002CFAE.10408@sancharnet.in"type="cite">Dear Uzo  , <br /><br /><blockquote type="cite">Hi, <br /> does
postgresqlsupport the ability to email as in SQL Server? I want to create a trigger which on input of a record will
sendout an email. Is this possible? <br /></blockquote><br /><a class="moz-txt-link-freetext"
href="http://pgmail.sourceforge.net/">http://pgmail.sourceforge.net/</a>is what you need. <br /><br /> Regards, <br
/><br/> Vishal Kashyap <br /><br /><br /> ---------------------------(end of broadcast)--------------------------- <br
/>TIP 3: if posting/reading through Usenet, please send an appropriate <br />      subscribe-nomail command to <a
class="moz-txt-link-abbreviated"href="mailto:majordomo@postgresql.org">majordomo@postgresql.org</a> so that your <br />
    message can get through to the mailing list cleanly <br /><br /></blockquote> 

Re: Triggers

From
Benoît BOURNON
Date:
I try pgmail and that is well running ...
fo security, do not use attachment files with your mail ...

try pgmail, you need to use pl/tclu ...

Ben


Sai Hertz And Control Systems wrote:

> Dear Uzo  ,
>
>> Hi,
>> does postgresql support the ability to email as in SQL Server? I want 
>> to create a trigger which on input of a record will send out an 
>> email. Is this possible?
>
>
> http://pgmail.sourceforge.net/ is what you need.
>
> Regards,
>
> Vishal Kashyap
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo@postgresql.org so that your
>      message can get through to the mailing list cleanly
>