pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Trigger that will execute external program
4+ messages / 4 participants
[nested] [flat]
* Re: Trigger that will execute external program
@ 2003-02-16 23:18 Tomasz Myrta <jasiek@klaster.net>
parent: David Loh <david@bizsurf.com>
1 sibling, 0 replies; 4+ messages in thread
From: Tomasz Myrta @ 2003-02-16 23:18 UTC (permalink / raw)
To: David Loh <david@bizsurf.com>; pgsql-sql
> 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Trigger that will execute external program
@ 2003-02-17 06:16 David Loh <david@bizsurf.com>
0 siblings, 2 replies; 4+ messages in thread
From: David Loh @ 2003-02-17 06:16 UTC (permalink / raw)
To: pgsql-sql
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Trigger that will execute external program
@ 2003-02-18 16:58 Hans-Jürgen Schönig <hs@cybertec.at>
parent: David Loh <david@bizsurf.com>
1 sibling, 1 reply; 4+ messages in thread
From: Hans-Jürgen Schönig @ 2003-02-18 16:58 UTC (permalink / raw)
To: pgsql-sql
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;
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Trigger that will execute external program
@ 2003-02-18 20:20 Jan Wieck <JanWieck@Yahoo.com>
parent: Hans-Jürgen Schönig <hs@cybertec.at>
0 siblings, 0 replies; 4+ messages in thread
From: Jan Wieck @ 2003-02-18 20:20 UTC (permalink / raw)
To: hs@cybertec.at; +Cc: pgsql-sql
Hans-Jürgen Schönig wrote:
>
> 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
>
> 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;
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2003-02-18 20:20 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-02-17 06:16 Trigger that will execute external program David Loh <david@bizsurf.com>
2003-02-16 23:18 ` Tomasz Myrta <jasiek@klaster.net>
2003-02-18 16:58 ` Hans-Jürgen Schönig <hs@cybertec.at>
2003-02-18 20:20 ` Jan Wieck <JanWieck@Yahoo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox