From: "Charles Clavadetscher" <clavadetscher@swisspug.org>
To: <pgsql-hackers@postgresql.org>
References: <016a01d0ede6$1fc6af00$5f540d00$@swisspug.org>
In-Reply-To: <016a01d0ede6$1fc6af00$5f540d00$@swisspug.org>
Subject: [DOCS] Missing COMMENT ON POLICY
Date: Sun, 13 Sep 2015 08:21:55 +0200
Message-ID: <016c01d0edec$81975df0$84c619d0$@swisspug.org>
MIME-Version: 1.0
Content-Type: multipart/mixed;
 boundary="----=_NextPart_000_016D_01D0EDFD.45202DF0"
Thread-Index: AQH/prVH2eW7nY5uhvsZoFxPI8toT53cilAw
Content-Language: de-ch
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

This is a multipart message in MIME format.

------=_NextPart_000_016D_01D0EDFD.45202DF0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hello

Well I gave it a try. I am still not very well aware how the process for
suggesting or submitting corrections work, but this is as far as I got.
In the attachment is a patch for the missing entry for POLICY in the
documentation on COMMENT that I mentioned earlier on pgsql-docs.

Hope this helps.

Regards
Charles

-----Original Message-----
From: pgsql-docs-owner@postgresql.org
[mailto:pgsql-docs-owner@postgresql.org] On Behalf Of Charles Clavadetscher
Sent: Sonntag, 13. September 2015 07:36
To: pgsql-docs@postgresql.org
Subject: [DOCS] Missing COMMENT ON POLICY

Hello

Lately I am working intensively with the documentation capabilities of
PostgreSQL and I noticed that, although the functionality is available in
9.5 to add a comment to a policy, there is no entry for in the documentation

http://www.postgresql.org/docs/9.5/static/sql-comment.html

Probably it would look like:

COMMENT ON POLICY policy_name ON table_name |

Between
OPERATOR FAMILY object_name USING index_method | and
[ PROCEDURAL ] LANGUAGE object_name |
 
Regards
Charles


-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

------=_NextPart_000_016D_01D0EDFD.45202DF0
Content-Type: application/softgrid-patch;
	name="comment_on_policy.patch"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
	filename="comment_on_policy.patch"

commit 0327154ba838894ccfb3420daed94b9832fd8bfa=0A=
Author: Charles Clavadetscher <clavadetscher@swisspug.org>=0A=
Date:   Sun Sep 13 08:08:00 2015 +0200=0A=
=0A=
    Added POLICY to list of COMMENT ON objects.=0A=
=0A=
diff --git a/doc/src/sgml/ref/comment.sgml b/doc/src/sgml/ref/comment.sgml=
=0A=
index 1030738..2133e77 100644=0A=
--- a/doc/src/sgml/ref/comment.sgml=0A=
+++ b/doc/src/sgml/ref/comment.sgml=0A=
@@ -43,6 +43,7 @@ COMMENT ON=0A=
   OPERATOR <replaceable class=3D"PARAMETER">operator_name</replaceable> (<=
replaceable class=3D"PARAMETER">left_type</replaceable>, <replaceable class=
=3D"PARAMETER">right_type</replaceable>) |=0A=
   OPERATOR CLASS <replaceable class=3D"PARAMETER">object_name</replaceable=
> USING <replaceable class=3D"parameter">index_method</replaceable> |=0A=
   OPERATOR FAMILY <replaceable class=3D"PARAMETER">object_name</replaceabl=
e> USING <replaceable class=3D"parameter">index_method</replaceable> |=0A=
+  POLICY <replaceable class=3D"PARAMETER">policy_name</replaceable> ON <re=
placeable class=3D"PARAMETER">table_name</replaceable> |=0A=
   [ PROCEDURAL ] LANGUAGE <replaceable class=3D"PARAMETER">object_name</re=
placeable> |=0A=
   ROLE <replaceable class=3D"PARAMETER">object_name</replaceable> |=0A=
   RULE <replaceable class=3D"PARAMETER">rule_name</replaceable> ON <replac=
eable class=3D"PARAMETER">table_name</replaceable> |=0A=

------=_NextPart_000_016D_01D0EDFD.45202DF0
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

------=_NextPart_000_016D_01D0EDFD.45202DF0--