NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commitdbe2946

committed

Doc: clarify use of NULL to drop comments and security labels.

This was only mentioned in the description of the text/label, whichare marked as being in quotes in the synopsis, which can causeconfusion (as witnessed on IRC).Also separate the literal and NULL cases in the parameter list, persuggestion from Tom Lane.Also add an example of dropping a security label.Dagfinn Ilmari Mannsåker, with some tweaks by meDiscussion:https://postgr.es/m/87sffqk4zp.fsf@wibble.ilmari.org

1 parente8fb2a7 commitdbe2946Copy full SHA for dbe2946

File tree

2 files changed

+34

-11

lines changed

doc/src/sgml/ref
- comment.sgml
- security_label.sgml

2 files changed

+34

-11

lines changed

`‎doc/src/sgml/ref/comment.sgml`

Lines changed: 12 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -66,7 +66,7 @@ COMMENT ON`
`66`	`66`	`TRIGGER <replaceable class="parameter">trigger_name</replaceable> ON <replaceable class="parameter">table_name</replaceable> \|`
`67`	`67`	`TYPE <replaceable class="parameter">object_name</replaceable> \|`
`68`	`68`	`VIEW <replaceable class="parameter">object_name</replaceable>`
`69`		`-} IS'<replaceable class="parameter">text</replaceable>'`
	`69`	`+} IS{<replaceable class="parameter">string_literal</replaceable> \| NULL }`
`70`	`70`
`71`	`71`	`<phrase>where <replaceable>aggregate_signature</replaceable> is:</phrase>`
`72`	`72`
`@@ -264,11 +264,19 @@ COMMENT ON`
`264`	`264`	`</varlistentry>`
`265`	`265`
`266`	`266`	`<varlistentry>`
`267`		`- <term><replaceable class="parameter">text</replaceable></term>`
	`267`	`+ <term><replaceable class="parameter">string_literal</replaceable></term>`
`268`	`268`	`<listitem>`
`269`	`269`	`<para>`
`270`		`- The new comment, written as a string literal; or <literal>NULL</literal>`
`271`		`- to drop the comment.`
	`270`	`+ The new comment contents, written as a string literal.`
	`271`	`+ </para>`
	`272`	`+ </listitem>`
	`273`	`+ </varlistentry>`
	`274`	`+`
	`275`	`+ <varlistentry>`
	`276`	`+ <term><literal>NULL</literal></term>`
	`277`	`+ <listitem>`
	`278`	`+ <para>`
	`279`	`+ Write <literal>NULL</literal> to drop the comment.`
`272`	`280`	`</para>`
`273`	`281`	`</listitem>`
`274`	`282`	`</varlistentry>`

`‎doc/src/sgml/ref/security_label.sgml`

Lines changed: 22 additions & 7 deletions

Original file line number	Diff line number	Diff line change
`@@ -44,7 +44,7 @@ SECURITY LABEL [ FOR <replaceable class="parameter">provider</replaceable> ] ON`
`44`	`44`	`TABLESPACE <replaceable class="parameter">object_name</replaceable> \|`
`45`	`45`	`TYPE <replaceable class="parameter">object_name</replaceable> \|`
`46`	`46`	`VIEW <replaceable class="parameter">object_name</replaceable>`
`47`		`-} IS'<replaceable class="parameter">label</replaceable>'`
	`47`	`+} IS{<replaceable class="parameter">string_literal</replaceable> \| NULL }`
`48`	`48`
`49`	`49`	`<phrase>where <replaceable>aggregate_signature</replaceable> is:</phrase>`
`50`	`50`
`@@ -179,11 +179,19 @@ SECURITY LABEL [ FOR <replaceable class="parameter">provider</replaceable> ] ON`
`179`	`179`	`</varlistentry>`
`180`	`180`
`181`	`181`	`<varlistentry>`
`182`		`- <term><replaceable class="parameter">label</replaceable></term>`
	`182`	`+ <term><replaceable class="parameter">string_literal</replaceable></term>`
`183`	`183`	`<listitem>`
`184`	`184`	`<para>`
`185`		`- The new security label, written as a string literal; or <literal>NULL</literal>`
`186`		`- to drop the security label.`
	`185`	`+ The new setting of the security label, written as a string literal.`
	`186`	`+ </para>`
	`187`	`+ </listitem>`
	`188`	`+ </varlistentry>`
	`189`	`+`
	`190`	`+ <varlistentry>`
	`191`	`+ <term><literal>NULL</literal></term>`
	`192`	`+ <listitem>`
	`193`	`+ <para>`
	`194`	`+ Write <literal>NULL</literal> to drop the security label.`
`187`	`195`	`</para>`
`188`	`196`	`</listitem>`
`189`	`197`	`</varlistentry>`
`@@ -194,12 +202,19 @@ SECURITY LABEL [ FOR <replaceable class="parameter">provider</replaceable> ] ON`
`194`	`202`	`<title>Examples</title>`
`195`	`203`
`196`	`204`	`<para>`
`197`		`- The following example shows how the security label of a tablemight`
`198`		`- be changed.`
	`205`	`+ The following example shows how the security label of a tablecould`
	`206`	`+ beset orchanged:`
`199`	`207`
`200`	`208`	`<programlisting>`
`201`	`209`	`SECURITY LABEL FOR selinux ON TABLE mytable IS 'system_u:object_r:sepgsql_table_t:s0';`
`202`		`-</programlisting></para>`
	`210`	`+</programlisting>`
	`211`	`+`
	`212`	`+ To remove the label:`
	`213`	`+`
	`214`	`+<programlisting>`
	`215`	`+SECURITY LABEL FOR selinux ON TABLE mytable IS NULL;`
	`216`	`+</programlisting>`
	`217`	`+ </para>`
`203`	`218`	`</refsect1>`
`204`	`219`
`205`	`220`	`<refsect1>`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commitdbe2946

File tree

2 files changed

2 files changed

`‎doc/src/sgml/ref/comment.sgml`

`‎doc/src/sgml/ref/security_label.sgml`

0 commit comments