Re: Add further details to ROW SHARE table level lock modes section

2022-04-13 Thread Erikjan Rijkers
Op 13-04-2022 om 20:00 schreef Alvaro Herrera: On 2022-Apr-04, PG Doc comments form wrote: I propose that it would be useful to explicitly state that `SELECT FOR KEY SHARE` AND `SELECT FOR NO KEY UPDATE` commands also acquire the ROW SHARE table level lock on target table(s). That is: ``` Confl

Re: Add further details to ROW SHARE table level lock modes section

2022-04-13 Thread Alvaro Herrera
On 2022-Apr-04, PG Doc comments form wrote: > I propose that it would be useful to explicitly state that `SELECT FOR KEY > SHARE` AND `SELECT FOR NO KEY UPDATE` commands also acquire the ROW SHARE > table level lock on target table(s). That is: > ``` > Conflicts with the EXCLUSIVE and ACCESS EXCLU