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 any
> column that is part of a
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 any
column that is part of a unique index. This is to allow concurrency
with forei
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
>
> (
>
> id int primary key,
>
> v
