From: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Simon Riggs <simon@2ndQuadrant.com>, Noah Misch <noah@leadboat.com>,
	Kevin Grittner <kgrittn@mail.com>, Andres Freund <andres@2ndquadrant.com>,
	pgsql-hackers@postgresql.org
Subject: Re: foreign key locks
Organization: 2ndQuadrant
References: <20121029121833.306930@gmx.com>
	<20121031193536.GA1651@tornado.leadboat.com>
	<CA+U5nMKK8oOcoxTtMO9ZgT6YYGYH2RQoDt15RXXyMh+Sp0tNmA@mail.gmail.com>
	<20121031202209.GF23139@alvh.no-ip.org>
User-Mail-Address: dimitri@2ndQuadrant.fr
Date: Mon, 05 Nov 2012 23:22:17 +0100
In-Reply-To: <20121031202209.GF23139@alvh.no-ip.org> (Alvaro Herrera's message
	of "Wed, 31 Oct 2012 17:22:10 -0300")
Message-ID: <m2zk2vg06e.fsf@2ndQuadrant.fr>
User-Agent: Gnus/5.130006 (Ma Gnus v0.6) Emacs/24.2 (darwin)
MIME-Version: 1.0
Content-Type: text/plain

Alvaro Herrera <alvherre@2ndquadrant.com> writes:
>> FOR NON KEY UPDATE
>> FOR KEY UPDATE
>> 
>> KEY is the default, so FOR UPDATE is a synonym of FOR KEY UPDATE
>
> Not really sure about the proposed syntax, but yes clearly we need some
> other syntax to mean "FOR NON KEY UPDATE".  I would rather keep FOR
> UPDATE to mean what I currently call FOR KEY UPDATE.  More proposals for
> the other (weaker) lock level welcome (but if you love FOR NON KEY
> UPDATE, please chime in too)

FOR ANY UPDATE, synonym of FOR UPDATE
FOR KEY UPDATE, optimized version, when it applies to your case

I also tend to think that we should better not change the current
meaning of FOR UPDATE and have it default to FOR ANY UPDATE.

Unless it's easy to upgrade from ANY to KEY, and do that automatically
at the right time, but I fear there lie dragons (or something).

Regards,
-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support