Re: How to handle deadlocks ?

In article <4q4tap$hum_at_dfw-ixnews7.ix.netcom.com> enelson3_at_ix.netcom.com(Eric D Nelson) writes:

    Date: 18 Jun 1996 00:30:17 GMT
    From: enelson3_at_ix.netcom.com(Eric D Nelson)

    I have also encountered deadlocks while doing a select. I didn't think     this would be possible.

I, too, though deadlocks from a select shouldn't happen. Once I saw it, however, I realized that it was easy: the select acquires shared locks, which could be acquired in a different order from an updater's exclusive locks --- deadlock. It is still true that readers should never deadlock against each other.

• Pat