Error during hash index scans can cause postgres halt!

Поиск
Список
Период
Сортировка
Искать
От
ykhuang
Тема
Error during hash index scans can cause postgres halt!
Дата
Msg-id
fqqco2$3mn$1@news.hub.org
Список
Дерево обсуждения
Error during hash index scans can cause postgres halt! "ykhuang" <hyk@ruc.edu.cn>
Re: Error during hash index scans can cause postgres halt! "Heikki Linnakangas" <heikki@enterprisedb.com>
Re: Error during hash index scans can cause postgres halt! Tom Lane <tgl@sss.pgh.pa.us>
Re: Error during hash index scans can cause postgres halt! Tom Lane <tgl@sss.pgh.pa.us>
Re: Error during hash index scans can cause postgres halt! "Heikki Linnakangas" <heikki@enterprisedb.com>
Re: Error during hash index scans can cause postgres halt! Tom Lane <tgl@sss.pgh.pa.us>
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 по дате отправления
От: Bruce Momjian
Дата:
От:
Дата:
FAQ