Szima Gabor ([EMAIL PROTECTED]) 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 matched rows 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
