Re: predicate locking

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?