From jasiek@klaster.net Mon Feb  17 06:27:13 2003
X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id D2E09475B85
	for <pgsql-sql@postgresql.org>; Mon, 17 Feb 2003 01:27:13 -0500 (EST)
Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66])
	by postgresql.org (Postfix) with ESMTP id 62D43475A9E
	for <pgsql-sql@postgresql.org>; Mon, 17 Feb 2003 01:27:08 -0500 (EST)
Received: from lamer.pl (localhost [127.0.0.1])
	by serwer.skawsoft.com.pl (Postfix) with ESMTP
	id 337D72B885; Mon, 17 Feb 2003 07:18:21 +0100 (CET)
From: "Tomasz Myrta" <jasiek@klaster.net>
To: "David Loh" <david@bizsurf.com>, <pgsql-sql@postgresql.org>
Subject: Re: Trigger that will execute external program
Date: Mon, 17 Feb 2003 07:18:21 +0800
Message-Id: <20030217071821.M2591@klaster.net>
In-Reply-To: <001e01c2d64c$2ab838d0$f92c2c0a@davidloh>
References: <001e01c2d64c$2ab838d0$f92c2c0a@davidloh>
X-Mailer: Open WebMail 1.62 20020221
X-OriginatingIP: 217.96.97.171 (jasiek)
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-2
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/364
X-Sequence-Number: 11762

> Hi all.
> I'd like to know if postgresql has the capability of execute 
> external program with the trigger, for example, I had a trigger call 
> "exceed_limit", when this trigger has fire, instead of update other 
> relations, it will also execute a external program '/bin/send_email',
>  is that possble ? If it's possible, can any of you guy please show 
> me how to do it ? Thanks in advance.
Read Postgresql documentation: 21.4. Trusted and Untrusted PL/Perl.
Probably C functions have also ability for running system commands.
Regards,
Tomasz Myrta



From david@bizsurf.com Mon Feb  17 06:15:10 2003
X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 15871475A7F
	for <pgsql-sql@postgresql.org>; Mon, 17 Feb 2003 01:15:10 -0500 (EST)
Received: from mail.sebasasia.com (unknown [203.115.208.204])
	by postgresql.org (Postfix) with ESMTP id 735B7475A5C
	for <pgsql-sql@postgresql.org>; Mon, 17 Feb 2003 01:15:08 -0500 (EST)
Message-ID: <001e01c2d64c$2ab838d0$f92c2c0a@davidloh>
From: "David Loh" <david@bizsurf.com>
To: <pgsql-sql@postgresql.org>
Subject: Trigger that will execute external program
Date: Mon, 17 Feb 2003 14:16:44 +0800
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_001B_01C2D68F.332511D0"
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/363
X-Sequence-Number: 11761

This is a multi-part message in MIME format.

------=_NextPart_000_001B_01C2D68F.332511D0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi all.
I'd like to know if postgresql has the capability of execute external progr=
am with the trigger, for example, I had a trigger call "exceed_limit", when=
 this trigger has fire, instead of update other relations, it will also exe=
cute a external program '/bin/send_email', is that possble ?
If it's possible, can any of you guy please show me how to do it ?
Thanks in advance.
------=_NextPart_000_001B_01C2D68F.332511D0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1106" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi all.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I'd like to know if postgresql has the cap=
ability=20
of execute external program with the trigger, for example, I had a trigger =
call=20
"exceed_limit", when this trigger has fire, instead of update other relatio=
ns,=20
it will also execute a external program '/bin/send_email', is that possble=
=20
?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>If it's possible, can any of you guy pleas=
e show me=20
how to do it ?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Thanks in advance.</FONT></DIV></BODY></HT=
ML>

------=_NextPart_000_001B_01C2D68F.332511D0--




From hs@cybertec.at Tue Feb  18 16:58:21 2003
X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 3F6CD47580B
	for <pgsql-sql@postgresql.org>; Tue, 18 Feb 2003 11:58:21 -0500 (EST)
Received: from news.hub.org (news.hub.org [64.49.215.80])
	by postgresql.org (Postfix) with ESMTP id D0C20475458
	for <pgsql-sql@postgresql.org>; Tue, 18 Feb 2003 11:58:20 -0500 (EST)
Received: by news.hub.org (Postfix, from userid 8)
	id BD0DC43A834; Tue, 18 Feb 2003 11:58:20 -0500 (EST)
From: =?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= <hs@cybertec.at>
X-Newsgroups: comp.databases.postgresql.sql
Subject: Re: Trigger that will execute external program
Date: Tue, 18 Feb 2003 17:58:45 +0100
Organization: Hub.Org Networking Services (http://www.hub.org)
Lines: 15
Message-ID: <3E526645.3010803@cybertec.at>
References: <001e01c2d64c$2ab838d0$f92c2c0a@davidloh>
Reply-To: hs@cybertec.at
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet@news.hub.org
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20020826
X-Accept-Language: en-us, en
To: pgsql-sql@postgresql.org
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/407
X-Sequence-Number: 11805

Try Peter Eisentrauts PL/Sh - it is pretty cool ...
If you don't like that try PL/PerlU or C.

    Regards,

        Hans

-- 
*Cybertec Geschwinde u Schoenig*
Ludo-Hartmannplatz 1/14, A-1160 Vienna, Austria
Tel: +43/1/913 68 09; +43/664/233 90 75
www.postgresql.at <http://www.postgresql.at>, cluster.postgresql.at 
<http://cluster.postgresql.at>, www.cybertec.at 
<http://www.cybertec.at>, kernel.cybertec.at <http://kernel.cybertec.at>




From JanWieck@Yahoo.com Tue Feb  18 20:22:25 2003
X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id C81F6475957
	for <pgsql-sql@postgresql.org>; Tue, 18 Feb 2003 15:22:25 -0500 (EST)
Received: from smtp011.mail.yahoo.com (smtp011.mail.yahoo.com
 [216.136.173.31])
	by postgresql.org (Postfix) with SMTP id 15DF647592C
	for <pgsql-sql@postgresql.org>; Tue, 18 Feb 2003 15:22:25 -0500 (EST)
Received: from psc.progress.com (HELO Yahoo.com) (janwieck@192.233.92.200 with
	plain)
	by smtp.mail.vip.sc5.yahoo.com with SMTP; 18 Feb 2003 20:22:25 -0000
Message-ID: <3E52958A.DFF0A13C@Yahoo.com>
Date: Tue, 18 Feb 2003 15:20:26 -0500
From: Jan Wieck <JanWieck@Yahoo.com>
Organization: Home
X-Mailer: Mozilla 4.8 [en] (Windows NT 5.0; U)
X-Accept-Language: en,ru
MIME-Version: 1.0
To: hs@cybertec.at
Cc: pgsql-sql@postgresql.org
Subject: Re: Trigger that will execute external program
References: <001e01c2d64c$2ab838d0$f92c2c0a@davidloh>
	<3E526645.3010803@cybertec.at>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/415
X-Sequence-Number: 11813

Hans-J=FCrgen Sch=F6nig wrote:
>=20
> Try Peter Eisentrauts PL/Sh - it is pretty cool ...
> If you don't like that try PL/PerlU or C.

And don't forget to do at least one of them in PL/TclU, just to have all
the animals in your zoo ;-)

Jan

>=20
>     Regards,
>=20
>         Hans
>=20
> --
> *Cybertec Geschwinde u Schoenig*
> Ludo-Hartmannplatz 1/14, A-1160 Vienna, Austria
> Tel: +43/1/913 68 09; +43/664/233 90 75
> www.postgresql.at <http://www.postgresql.at>, cluster.postgresql.at
> <http://cluster.postgresql.at>, www.cybertec.at
> <http://www.cybertec.at>, kernel.cybertec.at <http://kernel.cybertec.at>
>=20
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>=20
> http://archives.postgresql.org


--=20
#=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D JanWieck@Yahoo.com #