X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (neptune.hub.org [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id D942BD1B4BD
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 13 Jan 2004 09:12:20 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 80387-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 13 Jan 2004 05:11:50 -0400 (AST)
Received: from neptune.adelis.net (neptune.adelis.net [195.115.171.102])
	by svr1.postgresql.org (Postfix) with ESMTP id 68777D1B4A7
	for <pgsql-sql@postgresql.org>; Tue, 13 Jan 2004 05:11:38 -0400 (AST)
Received: from icqmail.com (ben.adelis.net [195.115.171.16])
	by neptune.adelis.net (Postfix) with ESMTP
	id 3A5E079182; Tue, 13 Jan 2004 10:01:26 +0100 (CET)
Message-ID: <4003B64B.7070409@icqmail.com>
Date: Tue, 13 Jan 2004 10:11:39 +0100
From: BenLaKnet <benlaknet@icqmail.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.5) Gecko/20031014 Thunderbird/0.3
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: aspire420@hotpop.com
Cc: beyaRecords - The home Urban music <uzo@beya-records.com>,
	pgsql-sql@postgresql.org
Subject: Re: Triggers
References: <6282673D-451A-11D8-A851-0003938366A4@beya-records.com>
	<4002CFAE.10408@sancharnet.in>
In-Reply-To: <4002CFAE.10408@sancharnet.in>
Content-Type: multipart/alternative;
	boundary="------------040106000706000407050203"
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200401/102
X-Sequence-Number: 16495

This is a multi-part message in MIME format.
--------------040106000706000407050203
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit


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
>

--------------040106000706000407050203
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
  <title></title>
</head>
<body>
<br>
<div class="moz-text-flowed"
 style="font-family: -moz-fixed; font-size: 12px;" lang="x-western">I
try pgmail and that is well running ...
<br>
fo security, do not use attachment files with your mail ...
<br>
<br>
try pgmail, you need to use pl/tclu ...
<br>
<br>
Ben</div>
<br>
<br>
Sai Hertz And Control Systems wrote:<br>
<blockquote type="cite" cite="mid4002CFAE.10408@sancharnet.in">Dear
Uzo&nbsp; ,
  <br>
  <br>
  <blockquote type="cite">Hi,
    <br>
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?
    <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>
&nbsp;&nbsp;&nbsp;&nbsp; subscribe-nomail command to <a class="moz-txt-link-abbreviated" href="mailto:majordomo@postgresql.org">majordomo@postgresql.org</a> so that your
  <br>
&nbsp;&nbsp;&nbsp;&nbsp; message can get through to the mailing list cleanly
  <br>
  <br>
</blockquote>
</body>
</html>

--------------040106000706000407050203--