postgres.git / summary / log / commit / refs

commit    6f8f9c2bdd30eef9c3f1858fb413f5f4e39d6010
Author:   Robert Haas <rhaas@postgresql.org>
Date:     Tue Jul 26 13:34:55 2011 +0000
First released in: 9.2.0, 9.0.5, 9.1.0

    Clarify which relkinds accept column comments.
    
    Per discussion with Josh Kupershmidt.


 doc/src/sgml/ref/comment.sgml | 7 +++++--
 1 file changed, 5 insertions(+), 2 deletions(-)

diff --git a/doc/src/sgml/ref/comment.sgml b/doc/src/sgml/ref/comment.sgml
index 53c6b0fcbc9..838f43fcbd5 100644
--- a/doc/src/sgml/ref/comment.sgml
+++ b/doc/src/sgml/ref/comment.sgml
@@ -24,9 +24,9 @@ PostgreSQL documentation
 COMMENT ON
 {
   TABLE <replaceable class="PARAMETER">object_name</replaceable> |
-  COLUMN <replaceable class="PARAMETER">table_name</replaceable>.<replaceable class="PARAMETER">column_name</replaceable> |
   AGGREGATE <replaceable class="PARAMETER">agg_name</replaceable> (<replaceable class="PARAMETER">agg_type</replaceable> [, ...] ) |
   CAST (<replaceable>source_type</replaceable> AS <replaceable>target_type</replaceable>) |
+  COLUMN <replaceable class="PARAMETER">relation_name</replaceable>.<replaceable class="PARAMETER">column_name</replaceable> |
   CONSTRAINT <replaceable class="PARAMETER">constraint_name</replaceable> ON <replaceable class="PARAMETER">table_name</replaceable> |
   CONVERSION <replaceable class="PARAMETER">object_name</replaceable> |
   DATABASE <replaceable class="PARAMETER">object_name</replaceable> |
@@ -86,7 +86,7 @@ COMMENT ON
   <variablelist>
    <varlistentry>
     <term><replaceable class="parameter">object_name</replaceable></term>
-    <term><replaceable class="parameter">table_name.column_name</replaceable></term>
+    <term><replaceable class="parameter">relation_name</replaceable>.<replaceable>column_name</replaceable></term>
     <term><replaceable class="parameter">agg_name</replaceable></term>
     <term><replaceable class="parameter">constraint_name</replaceable></term>
     <term><replaceable class="parameter">function_name</replaceable></term>
@@ -99,6 +99,9 @@ COMMENT ON
       aggregates, domains, functions, indexes, operators, operator classes,
       operator families, sequences, text search objects, types, and views can
       be schema-qualified.
+      When commenting on a column,
+      <replaceable class="parameter">relation_name</replaceable> must refer
+      to a table, view, or composite types.
      </para>
     </listitem>
    </varlistentry>


[parent: 65c033cbe913]