Foreign Key / Lock Problem

Hi,


I have two tables, tblMain and tblDetail. In tbldetail is a foreign key to
tblmain.

if i lock a row in tblmain with:

select * from tblmain where id=4 for update nowait

now i can't insert a row into tbldetail with the mainid 4

sth. like:

insert into tbldetail (id,mainid,name) values (default, 4, 'test')


is there any way to go around that problem?



greetz


Jens