On 30 Mar 2006 at 16:09, Alan McDonald wrote:

>but recently I see that it is possible to get the insertion into the
>log table out of this sequence so the log table records an insertion
>to the child sometimes before it records an insertion into the parent.
>This reverse sequence is obviously not possible into the child first
>since it would (does) raise an FK exception.

Is it possible that insertion into child table is done by trigger
on master table (or by any SP called from the trigger) and this
trigger is fired before logging trigger?

--
SY, Dimitry Sibiryakov.