From: Ivan P. <iva...@se...> - 2007-02-02 20:11:15
|
>> I fail to see how the trigger actions could be undone for a single >> record, sorry. >> By creating internal savepoint ? > > Per every row? It would be a performance killer. It is basically the same as creating savepoint inside trigger (sp) using WHEN ... DO. I do not know internals much, so I made short test, and indeed the impact on performace is just too big. Then I do not see any reasonable solution, other then making this "optimization" only for operations not using triggers (no a good idea, I know). Ivan |