Szima Gabor (sygma@marr.irisz.hu) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
foreign key check makes a big LOCK
Long Description
in: src/backend/utils/adt/ri_triggers.c
RI_FKey_check(), RI_FKey_noaction_upd(), RI_FKey_noaction_del(), etc..
checking the referential with SELECT FOR UPDATE.
After BEGIN TRANSACTION: the INSERT/DELETE/UPDATE calling foreign-key checks, and the SELECT FOR UPDATE locking ALL
matchedrows in referential table.
I modify ri_triggers.c (remove "FOR UPDATE"). This working.. but is correct?
Sample Code
No file was uploaded with this report