RE: [BUGS] foreign key check makes a big LOCK

2000-12-12 Thread Mikheev, Vadim
> 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/UP

[BUGS] foreign key check makes a big LOCK

2000-12-05 Thread pgsql-bugs
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.. che