> Is it possible to cancel update inside UPDATE trigger and perform delete
> and insert ?
> I have complex triggers for insert and delete and instead of writing also
> an update trigger i want to force
> update =delete+insert.

I think you want to use a VIEW with triggers that apply the operations to the real tables.

In that way you can replace any of the operations with whatever logic you want.


Sean