Re: [PERFORM] triggers, performance Was: Re: [GENERAL] rotate records

2006-03-01 Thread Jim C. Nasby
And what do those functions do? And do their options trigger other triggers? How about an EXPLAIN ANALYZE from a problem query, too. On Tue, Feb 28, 2006 at 11:24:34AM +0530, Jeevanandam, Kathirvel (IE10) wrote: I am using triggers for all the events (insert,delete,update) please find the

Re: [PERFORM] triggers, performance Was: Re: [GENERAL] rotate records

2006-02-28 Thread Jeevanandam, Kathirvel (IE10)
I am using triggers for all the events (insert,delete,update) please find the details below. trg_delpointtable BEFORE DELETE ON pointtable FOR EACH ROW EXECUTE PROCEDURE pp_delpointtable() trg_insdelpoints AFTER DELETE ON pointtable FOR EACH ROW EXECUTE PROCEDURE pp_insdelpoints()