Skip to content

Commit 225f539

Browse files
committed
Add POLICY to COMMENT documentation
COMMENT supports POLICY but the documentation hadn't caught up with that fact. Patch by Charles Clavadetscher Back-patch to 9.5 where POLICY was added.
1 parent fb98859 commit 225f539

File tree

1 file changed

+6
-3
lines changed

1 file changed

+6
-3
lines changed

doc/src/sgml/ref/comment.sgml

+6-3
Original file line numberDiff line numberDiff line change
@@ -43,6 +43,7 @@ COMMENT ON
4343
OPERATOR <replaceable class="PARAMETER">operator_name</replaceable> (<replaceable class="PARAMETER">left_type</replaceable>, <replaceable class="PARAMETER">right_type</replaceable>) |
4444
OPERATOR CLASS <replaceable class="PARAMETER">object_name</replaceable> USING <replaceable class="parameter">index_method</replaceable> |
4545
OPERATOR FAMILY <replaceable class="PARAMETER">object_name</replaceable> USING <replaceable class="parameter">index_method</replaceable> |
46+
POLICY <replaceable class="PARAMETER">policy_name</replaceable> ON <replaceable class="PARAMETER">table_name</replaceable> |
4647
[ PROCEDURAL ] LANGUAGE <replaceable class="PARAMETER">object_name</replaceable> |
4748
ROLE <replaceable class="PARAMETER">object_name</replaceable> |
4849
RULE <replaceable class="PARAMETER">rule_name</replaceable> ON <replaceable class="PARAMETER">table_name</replaceable> |
@@ -113,6 +114,7 @@ COMMENT ON
113114
<term><replaceable class="parameter">constraint_name</replaceable></term>
114115
<term><replaceable class="parameter">function_name</replaceable></term>
115116
<term><replaceable class="parameter">operator_name</replaceable></term>
117+
<term><replaceable class="parameter">policy_name</replaceable></term>
116118
<term><replaceable class="parameter">rule_name</replaceable></term>
117119
<term><replaceable class="parameter">trigger_name</replaceable></term>
118120
<listitem>
@@ -133,9 +135,9 @@ COMMENT ON
133135
<term><replaceable class="parameter">domain_name</replaceable></term>
134136
<listitem>
135137
<para>
136-
When creating a comment on a constraint on a table or a domain, these
137-
parameters specify the name of the table or domain on which the
138-
constraint is defined.
138+
When creating a comment on a constraint, a table, a domain or
139+
a policy these parameters specify the name of the table or domain on
140+
which the constraint is defined.
139141
</para>
140142
</listitem>
141143
</varlistentry>
@@ -315,6 +317,7 @@ COMMENT ON OPERATOR ^ (text, text) IS 'Performs intersection of two texts';
315317
COMMENT ON OPERATOR - (NONE, integer) IS 'Unary minus';
316318
COMMENT ON OPERATOR CLASS int4ops USING btree IS '4 byte integer operators for btrees';
317319
COMMENT ON OPERATOR FAMILY integer_ops USING btree IS 'all integer operators for btrees';
320+
COMMENT ON POLICY my_policy ON mytable IS 'Filter rows by users';
318321
COMMENT ON ROLE my_role IS 'Administration group for finance tables';
319322
COMMENT ON RULE my_rule ON my_table IS 'Logs updates of employee records';
320323
COMMENT ON SCHEMA my_schema IS 'Departmental data';

0 commit comments

Comments
 (0)