Thread

Commits

Fix grammar in README.tuplock
- 8a9b72c3ea40 12.0 landed

grammar - src/backend/access/heap/README.tuplock

Brad DeJong <bpd0018@gmail.com> — 2018-07-21T16:34:40Z

The sentences in question currently read ...

Finally, SELECT FOR KEY SHARE obtains a shared lock which only
prevents tuple removal and modifications of key fields. This last mode
implements a mode just strong enough to implement RI checks, i.e. it ensures
that tuples do not go away from under a check, without blocking when some
other transaction that want to update the tuple without changing its key.

The last sentence is the problem, the first is just for context.

1) "This last mode implements a mode ..." seems awkward and the term "mode"
is not used to describe the other 3 levels of tuple locking strength. The
phrasing
used for SELECT FOR UPDATE ("This is the lock level that ...") is better.

2) noun/verb agreement
    ... transaction that want ...
   should be either
    ... transaction that wants ... or ... transactions that want ...

3) mismatched clauses
    ... without blocking when ... transactions that want ...
    should be either
    ... without blocking ... transactions that want ...
    or
    ... without blocking when ... transactions want ...

The first says that our transaction's shared lock is not blocking other
transactions.

4) the "some other" in "some other transaction" just seems unnecessary.

Putting it all together, the attached patch changes the last sentence to ...

This lock level is just strong enough to implement RI checks, i.e. it
ensures
that tuples do not go away from under a check, without blocking transactions
that want to update the tuple without changing its key.

Re: grammar - src/backend/access/heap/README.tuplock

Alvaro Herrera <alvherre@2ndquadrant.com> — 2018-07-27T14:59:53Z

I agree with all you say here; these were all my mistakes.  Pushed
patch, thanks.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services