Re: AccessExclusiveLock on tuple? - Mailing list pgsql-general

From Christophe Pettus
Subject Re: AccessExclusiveLock on tuple?
Date
Msg-id FE877E8B-1A19-4B69-B245-4EE34F81AF8E@thebuild.com
Whole thread Raw
In response to Re: AccessExclusiveLock on tuple?  (Bill Moran <wmoran@potentialtech.com>)
Responses Re: AccessExclusiveLock on tuple?
List pgsql-general
On Dec 2, 2015, at 9:25 AM, Bill Moran <wmoran@potentialtech.com> wrote:

> No. See the section on row level locks here:
> http://www.postgresql.org/docs/9.4/static/explicit-locking.html

That wasn't quite my question.  I'm familiar with the row-level locking and the locking messages in general, but this
messageimplies there is such a thing as an AccessExclusiveLock on a tuple, which is new to me.  I wasn't able to
producethis message experimentally doing various combinations of UPDATE statements and SELECT FOR UPDATEs, or even with
explicitLOCK ACCESS EXCLUSIVE MODE, thus the question. 

--
-- Christophe Pettus
   xof@thebuild.com



pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: AccessExclusiveLock on tuple?
Next
From: Bill Moran
Date:
Subject: Re: AccessExclusiveLock on tuple?