Re: Triggers and table mutation

Hello Frank,

use stored procedures/functions to perform updates or inserts, and call it from the trigger.

Hope this helps,
Igor

Frank W Phillips JR wrote:
>
> I need to write an update trigger on a table but the trigger may need to
> update and/or insert additional records into the same table. Obviously
> this is not natively supported, the infamous table mutating error. Any
> ideas on how to handle this?

-- 
Igor Sereda,
ITC, Russia