Re: [HACKERS] RI_FKey_check: foreign key constraint blocks parall

2002-11-16 Thread Mikheev, Vadim
> > > void > > > heap_mark4fk_lock_acquire(Relation relation, HeapTuple tuple) { Just wonder how are you going to implement it - is it by using some kind of "read-locks", ie FK transaction "locks" PK to prevent delete (this is known as "pessimistic" approach)? About two years ago we discussed with

Re: [HACKERS] RI_FKey_check: foreign key constraint blocks parall

2002-11-15 Thread Stephan Szabo
On Fri, 15 Nov 2002, Mikheev, Vadim wrote: > Just wonder how are you going to implement it - is it by using > some kind of "read-locks", ie FK transaction "locks" PK to prevent > delete (this is known as "pessimistic" approach)? > About two years ago we discussed with Jan "optimistic" approach > w