pgsql: doc: Mention the level of locks taken on objects in COMMENT - Mailing list pgsql-committers

doc: Mention the level of locks taken on objects in COMMENT

This information was nowhere to be found.  This adds one note on the
page of COMMENT, and one note in the section dedicated to explicit
locking, both telling that a SHARE UPDATE EXCLUSIVE lock is taken on the
object commented.

Author: Nikolai Berkoff
Reviewed-by: Laurenz Albe
Discussion:
https://postgr.es/m/_0HDHIGcCdCsUyXn22QwI2FEuNR6Fs71rtgGX6hfyBlUh5rrnE2qMmvIFu9EY4Pijr2gUmJEAXCjuNU2Oxku9TryLp9CdHllpsCfN3gD0-Y=@pm.me
Backpatch-through: 10

Branch
------
REL_12_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/e58345f5d11075fb4fbec894786f61293a4ce738

Modified Files
--------------
doc/src/sgml/mvcc.sgml        | 9 +++++----
doc/src/sgml/ref/comment.sgml | 5 +++++
2 files changed, 10 insertions(+), 4 deletions(-)