Re: [HACKERS] [GENERAL] deadlock with truncate and foreing keys

2008-02-18 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > On Mon, 18 Feb 2008, Tom Lane wrote: >> but right offhand I see no reason for it to do so --- it doesn't >> *do* anything with fk_rel except close it again. Likewise >> RI_FKey_keyequal_upd_fk doesn't seem to really need to touch the >> pk_rel. Is there

Re: [HACKERS] [GENERAL] deadlock with truncate and foreing keys

2008-02-18 Thread Stephan Szabo
On Mon, 18 Feb 2008, Tom Lane wrote: > Alexey Nalbat <[EMAIL PROTECTED]> writes: > > create table t1 ( id integer primary key, name text ); > > create table t2 ( id integer references t1 ); > > insert into t1 values ( 1 ); > > insert into t2 values ( 1 ); > > > Then two concurrent transactions sta

Re: [HACKERS] [GENERAL] deadlock with truncate and foreing keys

2008-02-18 Thread Tom Lane
Alexey Nalbat <[EMAIL PROTECTED]> writes: > create table t1 ( id integer primary key, name text ); > create table t2 ( id integer references t1 ); > insert into t1 values ( 1 ); > insert into t2 values ( 1 ); > Then two concurrent transactions start. > /* 1 */ begin; > /* 1 */ truncate t2; >