You are correct about the reserved lock. I looked back at my notes
instead of using memory. It is only set when the database is about to
have something written to it, and it stops further reserved locks from
being set. A reserved lock is promoted to a pending lock which stops
further shared
John Stanton <[EMAIL PROTECTED]> wrote:
How about the case of:
BEGINsets reserved lock on thread one
You mean BEGIN IMMEDIATE, right?
SELECT promotes lock to shared on thread one
I'm not sure what you mean by "promotes" here. If anything, RESERVED
lock is a superset of
2 matches
Mail list logo