On 10/19/07, yogesh <yogesh.arora.daffodil@xxxxxxxxx> wrote: > 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. Yes, it's right. Triggers are part of a transaction (or run their own) so if the trigger fails, so does the transaction. If you really need to have something insert rather or not the transaction succeeds, you can either use savepoints so that you can roll back to before the error then insert the row anyway, or use dblink to connect to the db through another backend and commit your data that way. You might want to give more info on exactly what you're trying to do so the folks on the list can make better informed recommendations. ---------------------------(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