> > Can you able to give some test cases? Here i have tried, but unable to > > detect deadlock. > > Not a complete or tested example, but: > create table a (a int primary key); > create table b ( b int references a); > insert into a values (1); > insert into a values (2); > Transaction 1: begin; > Transaction 2: begin; > Transaction 1: insert into b values (1); > Transaction 2: insert into b values (2); > Transaction 1: insert into b values (2); > Transaction 2: insert into b values (1); > > - This really shouldn't be a deadlock, but given the locking level the > foreign keys currently use I'm pretty sure it'd cause one.
It shouldn't be, but it is detected. But i am able to eliminate it using the lock in share row exclusive mode. Am i right using this lock? regards, bhuvaneswaran > > BTW, do we have any link about deadlock detection during insert command as > > we have for update command? > > Not sure really. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
