Posted by Wojto on 06/11/07 18:55

Well.. to be honest I need to solve this problem as academic exercise...
It is rather didactic than business problem. So I need to enforce the
relationship and it must be done with trigger. It will be checked by
trial of puting wrong data in the tables (rollback) and than correct
data (normal commit). But with my declaration I can't put anything in
the tables... The trigger is fired just after the insert while I need it
to be fired, lets say, on commit. So this is the "real" prblem :-)

Thanx and sorry for this mess :-)

[Back to original message]