Postgres Pro
Downloads
Home   >   mailing lists

Re: Trigger that will execute external program - Mailing list pgsql-sql

From Tomasz Myrta
Subject Re: Trigger that will execute external program
Date
Msg-id 20030217071821.M2591@klaster.net
Whole thread Raw
In response to Trigger that will execute external program  ("David Loh" <david@bizsurf.com>)
List pgsql-sql
Tree view 
> 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

pgsql-sql by date:

Previous
From: "David Loh"
Date:
Subject: Trigger that will execute external program
Next
From: Rajesh Kumar Mallah
Date:
Subject: Re: is current_timestamp unique for a transaction?