Does Postgresql apply the same type of locks on UPDATE with range condition and on UPDATE with in-set condition?

0 votes

1 answer

198 views

                          Does Postgresql apply the same type of locks on UPDATE with a range condition and on UPDATE with in-set condition?

E.g. will the queries:

1. UPDATE table WHERE id IN (1,2,3,4,5,6,7,8,9,10);
2. UPDATE table WHERE id >= 1 AND id < 11;

Cause the same type of locks on table?

Asked by origaminal (193 rep)

Jun 10, 2020, 05:19 PM
Last activity: Jun 17, 2025, 01:01 AM

Does Postgresql apply the same type of locks on UPDATE with range condition and on UPDATE with in-set condition?

Related Questions