Re: Question about tuple´s lock

Em 24/10/2023 17:31, Tom Lane escreveu: > Carlos Alves writes: > >> I need some help to understand why a transaction wiht a row delete >> aquire a AccessExclusiveLock and a row update a ExclusiveLock. > > UPDATE can use the weaker lock type if it's not modifying a

Re: Question about tuple´s lock

Em 24/10/2023 13:27, Carlos Alves escreveu: > Hi! > > I need some help to understand why a transaction wiht a row delete aquire a > AccessExclusiveLock and a row update a ExclusiveLock. > > To ilustrate, a made this scenario: > > create table tblock > &

Question about tuple´s lock

uires a AccessExclusiveLock in the tuple insteead of ExclusiveLock? Bellow, a image of a query over pg_locks: PostgreSQL version: 13 OS: Centos 7 Thanks in advance. -- Carlos Alves Especialista Sia Trecho 08, lotes 245 / 255 / 265 || +55 (61) 3039-9700 71205-080 || Guará || Brasília,