>
> But yes, by the time you do a select on OLD.fk2 from
> the master_table, the record is already gone.

i've noticed this behavior and i was surprised. Isn't it temporary
violation of foreign key fk2? (it reference to non-existing master record)

Regards, Tomek