Re: Trigger AFTER UPDATE OR INSERT

On 10/19/07, yogesh <yogesh(dot)arora(dot)daffodil(at)gmail(dot)com> 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.