grant_lock_modes.out

application/octet-stream

Filename: grant_lock_modes.out

Type: application/octet-stream

Part: 0

Message: Re: GRANT/REVOKE locking semantics in get_object_address()

# Case 1: AccessShareLock (current PG18)
s2: grant   # waits until commit
s3: select  # succeeds immediately
s1: commit1 # release lock, grant finishes

# Case 2: ShareUpdateExclusiveLock (hypothetical stronger locking)
s2: grant   # waits until commit
s3: select  # also waits until commit (autovacuum/readers blocked)
s1: commit1 # release lock, grant and select both finish