Re: [GENERAL] Trigger (Calling a Procedure)

2006-08-15 Thread Harpreet Dhaliwal
Its actually something like the trigger should start a C function after insert and the C function has the ECPG code for some more inserts. Its similar to the way we dynamically load a shared library while executing a stored procedure, as in , executing a fucntion in C file using stored procedure/

Re: [GENERAL] Trigger (Calling a Procedure)

2006-08-15 Thread Harpreet Dhaliwal
I got your point. however, my requirement is something like this. The trigger shold start another function (a stored procedure) after any event is fired.   how do I accomplish this goal?   Harpreet  On 8/16/06, Michael Fuhr <[EMAIL PROTECTED]> wrote: On Wed, Aug 16, 2006 at 01:35:47AM -0400, Harpr

Re: [GENERAL] Trigger (Calling a Procedure)

2006-08-15 Thread Michael Fuhr
On Wed, Aug 16, 2006 at 01:35:47AM -0400, Harpreet Dhaliwal wrote: > I'm trying to create a trigger with the following definition: > > CREATE TRIGGER insert_price_change AFTER INSERT OR DELETE OR UPDATE ON > raw_email > FOR EACH ROW EXECUTE PROCEDURE add_one(1); > > Procedure / Function add_one