Hello frnds, I have a trigger on a table with After UPDATE OR INSERT ..that insert a record in an another table..........If the Trigger Fire Correctly the row is inserted or updated in the database as the case is. But if it is not fire correctly then the table is also not updated on which the trigger is.............. Is it the right .................? if yes......How to insert the record in the table if the trigger is failed. Regards, Yogesh Arora. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match