Re: trigger to run external script

On Tue, 26 Sep 2000, Chau, Artemis wrote:

> All,
> I want to have a trigger for a table that whenever a new record is created
> to run an external shell script on Unix.
> Any suggestion?
>
> -- Artemis

Artemis - what is it you want the script to do? I do this - but my
IF is perl. When the user INSERTs INTO a table (without error)
my script generates email to any interested parties. If the user
makes an error my script dumps detailed info (including username)
into a log file.

If you want to do something similar, it is relatively easy via
shell script or perl...presumably in any interface really.
So the issue is only: do your users enter data from a psql sh prompt
or from an IF? If they use psql then you could define a trigger that
makes an entry into a second table...

--------------------------------------------------------------------
SVCMC - Center for Behavioral Health
--------------------------------------------------------------------
Thomas Good tomg@ { admin | q8 } .nrnet.org
IS Coordinator / DBA Phone: 718-354-5528
Fax: 718-354-5056
--------------------------------------------------------------------
Powered by: PostgreSQL s l a c k w a r e FreeBSD:
RDBMS |---------- linux The Power To Serve
--------------------------------------------------------------------