Loïc Rollus wrote:
> It's ok.
> Before the insert, The foreign key constraint locked the row. If transaction A and B lock the row with
> FK, before doing UPDATE, they were stuck.
> I found a solution by creating an "before insert" trigger with a simple SELECT FROM UPDATE on the row.
You mean "SELECT FOR UPDATE", richt?
Great that you could figure out where the problem was.
Yours,
Laurenz Albe