Re: role attributes are missing from this page

2022-04-13 Thread Keith Wanta
Thanks! Because I'm getting oid, I might need glasses. On Tue, Apr 12, 2022 at 2:29 PM Tom Lane wrote: > PG Doc comments form writes: > > Issue #1: > > "old" is a keyword, but I cannot query the old column explicitely with > > surrounding quotes. > > SELECT "old" FROM pg_roles; > > Look closer

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

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