Thread: Triggers invoking a stored procedure or a C function
Hi,
Conventionally a trigger would fire a few sql queries on a particular event and we have standard code for that.
My requirement is to start a stored procedure or a C function as a trigger action.
Is this possible?
Thanks,
~Harpreet
# harpreet.dhaliwal01@gmail.com / 2006-08-16 11:55:39 -0400: > Hi, > Conventionally a trigger would fire a few sql queries on a particular event > and we have standard code for that. > > My requirement is to start a stored procedure or a C function as a trigger > action. > > Is this possible? Besides the fact that PostgreSQL doesn't have stored procedures, only "SQL-invoked routines", both SQL and external, you can. After all, http://www.postgresql.org/docs/8.1/static/sql-createtrigger.html says CREATE TRIGGER name { BEFORE | AFTER } { event [ OR ... ] } ON table [ FOR [ EACH ] { ROW | STATEMENT } ] EXECUTE PROCEDURE funcname ( arguments ) The above page also links to "33.4. A Complete Example" (http://www.postgresql.org/docs/8.1/static/trigger-example.html), which revolves around a trigger function written in C. -- How many Vietnam vets does it take to screw in a light bulb? You don't know, man. You don't KNOW. Cause you weren't THERE. http://bash.org/?255991