On Dec 2, 2015, at 9:50 AM, Bill Moran <wmoran@potentialtech.com> wrote:
> Then wait for a little while and the message will be logged.
Well, yes and no :) :
2015-12-02 10:07:40.281 PST,"xof","xof",8465,"[local]",565f3365.2111,4,"UPDATE waiting",2015-12-02 10:07:33
PST,3/12,1000056,LOG,00000,"process8465 still waiting for ShareLock on transaction 1000055 after 1001.203 ms","Process
holdingthe lock: 8428. Wait queue: 8465.",,,,"while updating tuple (0,1) in relation ""x""","update x set
a='a';",,,"psql"
Note that it's waiting for a ShareLock, not an AccessExclusiveLock, thus my question.
Just to clarify, my very specific question is about "AccessExclusiveLock".
--
-- Christophe Pettus
xof@thebuild.com