>> My sessions look like:
>>
>> begin;
>> update t set a = 1 where c = 1;
>> select * from t where c = 1;
>> end;
>
>Ops. Do you have indices over table t?
Yes. It has the primary key, so has an btree index.
>Btree-s are still using page-level locking and don't release
>locks when leave index page to fetch row from relation.
>Seems that this causes deadlocks more often than I thought -:(
>
>Marc? I can fix this today and I'll be very careful...
>Ok?
Please let me know if you fix it. I will run the test again.
---
Tatsuo Ishii
