Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 6EBB26337C2
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 12 Aug 2009 03:15:06 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 64769-03 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 12 Aug 2009 06:15:03 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-yw0-f183.google.com (mail-yw0-f183.google.com
	[209.85.211.183])
	by mail.postgresql.org (Postfix) with ESMTP id 48436632B7F
	for <pgsql-sql@postgresql.org>; Wed, 12 Aug 2009 03:15:03 -0300 (ADT)
Received: by ywh13 with SMTP id 13so5370498ywh.15
	for <pgsql-sql@postgresql.org>; Tue, 11 Aug 2009 23:15:02 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:message-id:subject:from:to:cc:content-type;
	bh=zbPWHq0mClGmfZR6fyXsvcUItoRCsoQWorGjivmd2M4=;
	b=CAorCl2wCqBefZydDvxFGBLo9y3iyCg8zUPPaGXgNywlHt/5SvWKyKJ9wEQgVeWpyP
	tU781UYshx1J2Khl4LB0teXpd2npBtc3/hTeGXQI9oPrnxJiI/hLveSR34MfMzoz8cex
	GOjK6esSCBjQ+btotryan8VDzMEWMypWBmxxI=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=s1Hbty7RIEBmhJqQT9CJKQ8YOIjDGNsx6tWssrpASMKjCROotsnwyJpwTi1lcXg80V
	nx9WtZCcvrBjHCwSkjQNXu4PdVGLt7VTo+0KBL5vWSlP534NApeWZryTIw22PPp6KQEX
	/8hD6k74iJonjZ2YVoWbOie8IuaveVGM7YO5Q=
MIME-Version: 1.0
Received: by 10.91.161.39 with SMTP id n39mr388344ago.88.1250057702497; Tue,
	11 Aug 2009 23:15:02 -0700 (PDT)
In-Reply-To: <EC8A0653E149420D898593D05B1E07FF@ramasubramanian>
References: 
 <E30C7040DE22624185BAD4093190B54437BE5DB49C@EX2007-MBX-2.uz.kuleuven.ac.be>
	<EC8A0653E149420D898593D05B1E07FF@ramasubramanian>
Date: Wed, 12 Aug 2009 16:15:02 +1000
Message-ID: <bf54be870908112315k3de42370iacc59e48d15c3912@mail.gmail.com>
Subject: Re: mail alert
From: Shoaib Mir <shoaibmir@gmail.com>
To: ramasubramanian <ramasubramanian.g@renaissance-it.com>
Cc: Jan Verheyden <jan.verheyden@uz.kuleuven.ac.be>, pgsql-sql@postgresql.org
Content-Type: multipart/alternative; boundary=0016362844c64e5f930470ebbded
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.598 tagged_above=-10 required=5
	tests=BAYES_00=-2.599, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200908/56
X-Sequence-Number: 32965

--0016362844c64e5f930470ebbded
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

> ----- Original Message -----
> *From:* Jan Verheyden <jan.verheyden@uz.kuleuven.ac.be>
> *To:* 'pgsql-sql@postgresql.org' <%27pgsql-sql@postgresql.org%27>
> *Sent:* Tuesday, August 11, 2009 6:31 PM
> *Subject:* [SQL] mail alert
>
>  Hi All,
>
>
>
> I was looking in what way it=92s possible to alert via mail when some
> conditions are true in a database.
>
>
>
>
I guess you might be able to do that by using PLPython, PLPerl or PLTcl and
using the standard functions for doing emails in there.

--=20
Shoaib Mir
http://shoaibmir.wordpress.com/

--0016362844c64e5f930470ebbded
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

<br><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"b=
order-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; paddin=
g-left: 1ex;"><div vlink=3D"purple" link=3D"blue" bgcolor=3D"#ffffff" lang=
=3D"EN-US"><blockquote dir=3D"ltr" style=3D"border-left: 2px solid rgb(0, 0=
, 0); padding-right: 0px; padding-left: 5px; margin-left: 5px; margin-right=
: 0px;">

  <div style=3D"font-family: arial; font-style: normal; font-variant: norma=
l; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adj=
ust: none; font-stretch: normal;">----- Original Message ----- </div>
  <div style=3D"background: rgb(228, 228, 228) none repeat scroll 0% 0%; -m=
oz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -mo=
z-background-inline-policy: -moz-initial; font-family: arial; font-style: n=
ormal; font-variant: normal; font-weight: normal; font-size: 10pt; line-hei=
ght: normal; font-size-adjust: none; font-stretch: normal;">
<b>From:</b>=20
  <a title=3D"jan.verheyden@uz.kuleuven.ac.be" href=3D"mailto:jan.verheyden=
@uz.kuleuven.ac.be" target=3D"_blank">Jan Verheyden</a> </div>
  <div style=3D"font-family: arial; font-style: normal; font-variant: norma=
l; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adj=
ust: none; font-stretch: normal;"><b>To:</b> <a title=3D"pgsql-sql@postgres=
ql.org" href=3D"mailto:%27pgsql-sql@postgresql.org%27" target=3D"_blank">&#=
39;pgsql-sql@postgresql.org&#39;</a> </div>

  <div style=3D"font-family: arial; font-style: normal; font-variant: norma=
l; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adj=
ust: none; font-stretch: normal;"><b>Sent:</b> Tuesday, August 11, 2009 6:3=
1=20
  PM</div>
  <div style=3D"font-family: arial; font-style: normal; font-variant: norma=
l; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adj=
ust: none; font-stretch: normal;"><b>Subject:</b> [SQL] mail alert</div>

  <div><br></div>
  <div>
  <p>Hi All,</p>
  <p>=A0</p>
  <p>I was looking in what way it=92s possible to alert via mail=20
  when some conditions are true in a database.</p>
  <p>=A0</p>
  </div></blockquote></div></blockquote><div><br>I guess you might be able =
to do that by using PLPython, PLPerl or PLTcl and using the standard functi=
ons for doing emails in there.<br></div></div><br>-- <br>Shoaib Mir<br>
<a href=3D"http://shoaibmir.wordpress.com/">http://shoaibmir.wordpress.com/=
</a><br>

--0016362844c64e5f930470ebbded--