--On 23. Januar 2013 15:12:00 +0000 Alvaro Herrera 
<alvherre(at)alvh(dot)no-ip(dot)org> wrote:

> This patch introduces two additional lock modes for tuples: "SELECT FOR
> KEY SHARE" and "SELECT FOR NO KEY UPDATE".  These don't block each
> other, in contrast with already existing "SELECT FOR SHARE" and "SELECT
> FOR UPDATE".  UPDATE commands that do not modify the values stored in
> the columns that are part of the key of the tuple now grab a SELECT FOR
> NO KEY UPDATE lock on the tuple, allowing them to proceed concurrently
> with tuple locks of the FOR KEY SHARE variety.

Out of curiousity, shouldn't we update chapter 13.3.2 in the docs to 
mention the additional new lock modes, too?


-- 
Thanks

	Bernd

In response to

• pgsql: Improve concurrency of foreign key locking at 2013-01-23 15:12:00 from Alvaro Herrera

pgsql-hackers by date

Next:	From: Dimitri Fontaine	Date: 2013-01-31 11:10:53
	Subject: Re: pg_dump --pretty-print-views
Previous:	From: John R Pierce	Date: 2013-01-31 10:15:01
	Subject: Re: Should pg_dump dump larger tables first?

pgsql-committers by date

Next:	From: Magnus Hagander	Date: 2013-01-31 14:10:03
	Subject: pgsql: Properly zero-pad the day-of-year part of the win32 buildnumber
Previous:	From: Tatsuo Ishii	Date: 2013-01-31 07:04:45
	Subject: pgsql: Add --aggregate-interval option.