Re: predicate locking knowledge

"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> Attached is a patch for the documentation.  We currently state that we
> don't know of any production DBMS which uses predicate locking.  Current
> versions of at least two commercial products (Sybase ASE and Microsoft
> SQL Server) do use it.

Are they actually doing fully-general predicate locks (able to cope with
arbitrary predicate conditions), or merely index range locks?  I don't
mind expanding the docs, but the context of the statement is the cost of
doing general predicate locking, and pointing to DBMSes that do a subset
case doesn't make that statement invalid.

            regards, tom lane