Error during hash index scans can cause postgres halt! - Mailing list pgsql-bugs

From ykhuang
Subject Error during hash index scans can cause postgres halt!
Date
Msg-id fqqco2$3mn$1@news.hub.org
Whole thread Raw
Responses Re: Error during hash index scans can cause postgres halt!
List pgsql-bugs
recurred through deadlock.

client1:
 create table test(a int);
 create index id on test using hash(a);
 insert into test values(1);
 insert into test values(2);
 set enable_seqscan=off;
 begin;
 update test set a=a+1 where a=1;

client2:
 set enable_seqscan=off;
 begin;
 update test set a=a+1 where a=2;

client1:
  update test set a=a+1 where a=2;

client2:
 update test set a=a+1 where a=1;

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Problem identifying constraints which should not be inherited
Next
From: ""
Date:
Subject: BUG #4018: Installation failure