> As I could cancel a transaction inside a triggers?
>
> I want something like:
>
> if (new.IDE > 10) then
> TRANSACTION ROLLBACK;

You can't do that directly.

You would raise an exception at the database level, which would stop the current operation and return control back to your application.

From there you could rollback the transaction.


Sean