Re: predicate locking - Mailing list pgsql-sql

From Tom Lane
Subject Re: predicate locking
Date
Msg-id 23768.1118588642@sss.pgh.pa.us
Whole thread Raw
In response to predicate locking  (Daniel Roth <dan.c.roth@gmail.com>)
Responses Re: predicate locking  (Daniel Roth <dan.c.roth@gmail.com>)
List pgsql-sql
Daniel Roth <dan.c.roth@gmail.com> writes:
> But MSSQL (SQL Server) does predicate locking.

> Places a range lock on the data set, preventing other users from
> updating or inserting rows into the data set until the transaction is
> complete. This is the most restrictive of the four isolation levels.

Range locks are a far cry from general predicate locks.
        regards, tom lane

PS: kindly don't email me privately while posting the same message to
the lists.  You think I have time to answer things twice?


pgsql-sql by date:

Previous
From: Daniel Roth
Date:
Subject: predicate locking
Next
From: Daniel Roth
Date:
Subject: Re: predicate locking