Re: predicate locking

Hi Tom

Apologies for my previous double post.

In "12.2.2.1. Serializable Isolation versus True Serializability"

It sates: "To guarantee true mathematical serializability, it is
necessary for a database system to enforce predicate locking, which
means that a transaction cannot insert or modify a row that would have
matched the WHERE condition of a query in another concurrent
transaction"

Now that is exactly whats happens when you use SERIALIZABLE is MSSQL.

So, by the postgres help documentation's definition of predicate
locking, MSSQL does predicate locking.

All I am trying to do is correct the help documentation - 12.2.2.1 "so
far as we are aware no other production DBMS does either."

Regards,

Daniel Roth

On 6/12/05, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Daniel Roth <dan(dot)c(dot)roth(at)gmail(dot)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?
>