Re: COMMENT ON lock

Laurenz Albe <laurenz.albe@cybertec.at>

From: Laurenz Albe <laurenz.albe@cybertec.at>

To: "nikolai.berkoff" <nikolai.berkoff@pm.me>, "pgsql-docs@lists.postgresql.org" <pgsql-docs@lists.postgresql.org>

Date: 2022-01-18T14:37:35Z

Lists: pgsql-docs

On Tue, 2022-01-18 at 14:11 +0000, nikolai.berkoff wrote:
> I wanted to know what lock the COMMENT ON command took and I had to look in the
> source code, makes sense to me that it should be documented.  I've also added
> it to the list of commands that take a SHARE UPDATE EXCLUSIVE lock.

+1, but SHARE ACCESS EXCLUSIVE should be marked up with <literal>.

Yours,
Laurenz Albe

Commits

doc: Mention the level of locks taken on objects in COMMENT
- 6fc08323b536 10.20 landed
- 44ab2dac12a7 11.15 landed
- e58345f5d110 12.10 landed
- 3ca40a2b18a0 13.6 landed
- a9009f59fff1 14.2 landed
- b2a76bb7d055 15.0 landed