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 Jan

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 with using