Re: making a trigger to a system call to a shell script - Mailing list pgsql-general

From Stephan Szabo
Subject Re: making a trigger to a system call to a shell script
Date
Msg-id 20020503090510.K67939-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Re: making a trigger to a system call to a shell script  (Alejandro Fernandez <ale@e-group.org>)
List pgsql-general
> Anyway, last step was to create a trigger so that I could monitor changes to my table remotely:
>
> create trigger trigger_alertme before insert or update on mytable for
> each row execute procedure alertme('blablabla');
>
> And this will not work: it returns:
>
> ERROR:  CreateTrigger: function alertme() does not exist

That's because trigger functions take no arguments and
return opaque.  Trigger arguments are passed specially
and not through normal arguments.  You need to write the
function to meet the trigger requirements (there's more information
in the documentation on trigger functions it looks like)



pgsql-general by date:

Previous
From: "David Siebert"
Date:
Subject: Foxpro
Next
From: "Joel Burton"
Date:
Subject: Re: problem with RULEs