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
Дата: