Commite58345f

committed

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

This information was nowhere to be found. This adds one note on thepage of COMMENT, and one note in the section dedicated to explicitlocking, both telling that a SHARE UPDATE EXCLUSIVE lock is taken on theobject commented.Author: Nikolai BerkoffReviewed-by: Laurenz AlbeDiscussion:https://postgr.es/m/_0HDHIGcCdCsUyXn22QwI2FEuNR6Fs71rtgGX6hfyBlUh5rrnE2qMmvIFu9EY4Pijr2gUmJEAXCjuNU2Oxku9TryLp9CdHllpsCfN3gD0-Y=@pm.meBackpatch-through: 10

1 parent5940d1b commite58345fCopy full SHA for e58345f

File tree

+10

-4

lines changed

+10

-4

lines changed

Lines changed: 5 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -950,11 +950,12 @@ ERROR: could not serialize access due to read/write dependencies among transact`
`950`	`950`	`<para>`
`951`	`951`	`Acquired by <command>VACUUM</command> (without <option>FULL</option>),`
`952`	`952`	`<command>ANALYZE</command>, <command>CREATE INDEX CONCURRENTLY</command>,`
	`953`	`+ <command>CREATE STATISTICS</command>, <command>COMMENT ON</command>,`
`953`	`954`	`<command>REINDEX CONCURRENTLY</command>,`
`954`		`- <command>CREATE STATISTICS</command>, and certain <command>ALTER`
`955`		`-INDEX</command> and <command>ALTER TABLE</command> variants (for full`
`956`		`- details see <xref linkend="sql-alterindex"/> and <xref`
`957`		`- linkend="sql-altertable"/>).`
	`955`	`+and certain<command>ALTER INDEX</command> and`
	`956`	`+<command>ALTER TABLE</command> variants`
	`957`	`+(for fulldetails see <xref linkend="sql-alterindex"/> and`
	`958`	`+<xreflinkend="sql-altertable"/>).`
`958`	`959`	`</para>`
`959`	`960`	`</listitem>`
`960`	`961`	`</varlistentry>`

Lines changed: 5 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -90,6 +90,11 @@ COMMENT ON`
`90`	`90`	`Comments are automatically dropped when their object is dropped.`
`91`	`91`	`</para>`
`92`	`92`
	`93`	`+ <para>`
	`94`	`+ A <literal>SHARE UPDATE EXCLUSIVE</literal> lock is acquired on the`
	`95`	`+ object to be commented.`
	`96`	`+ </para>`
	`97`	`+`
`93`	`98`	`<para>`
`94`	`99`	`For most kinds of object, only the object's owner can set the comment.`
`95`	`100`	`Roles don't have owners, so the rule for <literal>COMMENT ON ROLE</literal> is`

Comments

(0)