Re: Deadlock possibility in _bt_check_unique?

      I am really confused. Please keep the cool and explain me, if i am wrong. I could see this code in _bt_findinsertloc. There is a _bt_relandgetbuf, which releases lock on p1 and tries to acquire a lock on p2. I wrote ex lock in the place of BT_WRITE.

00589         for (;;)

00590         {
00591             BlockNumber rblkno = lpageop->btpo_next;

00592 
00593             rbuf = _bt_relandgetbuf(rel, rbuf, rblkno, BT_WRITE);

00594             page = BufferGetPage(rbuf);

00595             lpageop = (BTPageOpaque) PageGetSpecialPointer(page);

00596             if (!P_IGNORE(lpageop))

00597                 break;

00598             if (P_RIGHTMOST(lpageop))

00599                 elog(ERROR, "fell off the end of index \"%s\"",

00600                      RelationGetRelationName(rel));

00601         }

What is that, i am missing here?

Gokul.