I have a table with a trigger that updates a parent on insert/update.
basically keeps a sum of values in the children.

the parent row is assigned to a particular user. therefore, no 2 users
are ever inserting details that cause the same parent row to be updated.

I began getting lock conflicts on occasion. so, I made the triggers
that update the parent rows inactive.

Yet, today, I actually had on of the parent rows locked doing an update
myself on the parent row. The problem is that I still got a lock
conflict even though the triggers that update the parent row on insert
of the child row was rendered inactive.

I concluded the edit on the parent row and the transaction. I retried
the child insert from the other client, and it went through fine.

Is this possible?

FB 1.5

What could be going on?

Thanks,
Mitch