Re: Debugging deadlocks

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> Greg Stark <gsstark(at)mit(dot)edu> writes:
> > Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> >> I looked at Paul's first message and thought "nah, that won't work
> >> because ... because ... hmm ... hmmm ..."
>
> > For what it's worth, this would be very similar to how Oracle handles such
> > locks.
>
> [ slightly alarmed ] Do they have a patent on the way they do it?

Do we really want to know?...

A few minutes searching on a patent search site doesn't turn up anything
relevant though. It might have been part of Oracle's design from such an early
stage that they never thought it was patentable. It's not clear to me that it
is for that matter. The general idea of storing locks with the objects being
locked isn't really anything novel.

--
greg