Greetings,
I've seen locks with mode of AccessExclusiveLock and locktype of tuple a few times now but have never been able to reproduce one nor had a chance to dig into them and now have a couple questions on them:
* When is this kind of heavy lock on a row/tuple taken out? I've done some code spelunking but have yet to find anything.
* An AccessExcluciveLock on a tuple should only block all other access to the given tuple, yes? It won't block access at the table level? I ask since the manual only discusses AccessExclusiveLocks in the context of table level locking.
The only thing I've found so far on them is this old pgsql-general thread wherein Tom Lane essentially just says, "Yeah, it can happen and is an implementation detail that can change from version to version." That was on 9.4.x and the my most recent confirmed sighting was on a server running 11.3.
--