doc patch for ALTER TRIGGER - Mailing list pgsql-patches

Here's a doc patch for ALTER TRIGGER RENAME. Please apply if there are
no objections.

Thanks,

Joe
diff -cNr pgsql.cvs.orig/doc/src/sgml/ref/allfiles.sgml pgsql/doc/src/sgml/ref/allfiles.sgml
*** pgsql.cvs.orig/doc/src/sgml/ref/allfiles.sgml    Fri Apr 19 21:20:22 2002
--- pgsql/doc/src/sgml/ref/allfiles.sgml    Fri Apr 19 21:39:31 2002
***************
*** 40,45 ****
--- 40,46 ----
  <!entity alterDatabase      system "alter_database.sgml">
  <!entity alterGroup         system "alter_group.sgml">
  <!entity alterTable         system "alter_table.sgml">
+ <!entity alterTrigger       system "alter_trigger.sgml">
  <!entity alterUser          system "alter_user.sgml">
  <!entity analyze            system "analyze.sgml">
  <!entity begin              system "begin.sgml">
diff -cNr pgsql.cvs.orig/doc/src/sgml/ref/alter_trigger.sgml pgsql/doc/src/sgml/ref/alter_trigger.sgml
*** pgsql.cvs.orig/doc/src/sgml/ref/alter_trigger.sgml    Wed Dec 31 16:00:00 1969
--- pgsql/doc/src/sgml/ref/alter_trigger.sgml    Fri Apr 19 22:35:05 2002
***************
*** 0 ****
--- 1,178 ----
+ <!--
+ PostgreSQL documentation
+ -->
+
+ <refentry id="SQL-ALTERTRIGGER">
+  <refmeta>
+   <refentrytitle id="sql-altertrigger-title">
+    ALTER TRIGGER
+   </refentrytitle>
+   <refmiscinfo>SQL - Language Statements</refmiscinfo>
+  </refmeta>
+  <refnamediv>
+   <refname>
+    ALTER TRIGGER
+   </refname>
+   <refpurpose>
+    change the definition of a trigger
+   </refpurpose>
+  </refnamediv>
+  <refsynopsisdiv>
+   <refsynopsisdivinfo>
+    <date>2002-04-19</date>
+   </refsynopsisdivinfo>
+   <synopsis>
+ ALTER TRIGGER <replaceable class="PARAMETER">trigger</replaceable> ON <replaceable
class="PARAMETER">table</replaceable>
+     RENAME TO <replaceable class="PARAMETER">newname</replaceable>
+   </synopsis>
+
+   <refsect2 id="R2-SQL-ALTERTRIGGER-1">
+    <refsect2info>
+     <date>2002-04-19</date>
+    </refsect2info>
+    <title>
+     Inputs
+    </title>
+    <para>
+     <variablelist>
+
+      <varlistentry>
+       <term><replaceable class="PARAMETER"> trigger </replaceable></term>
+       <listitem>
+        <para>
+     The name of an existing trigger to alter.
+        </para>
+       </listitem>
+      </varlistentry>
+
+      <varlistentry>
+       <term><replaceable class="PARAMETER"> table </replaceable></term>
+       <listitem>
+        <para>
+     The name of the table on which this trigger acts.
+        </para>
+       </listitem>
+      </varlistentry>
+
+      <varlistentry>
+       <term><replaceable class="PARAMETER"> newname </replaceable></term>
+       <listitem>
+        <para>
+     New name for the existing trigger.
+        </para>
+       </listitem>
+      </varlistentry>
+
+     </variablelist>
+    </para>
+   </refsect2>
+
+   <refsect2 id="R2-SQL-ALTERTRIGGER-2">
+    <refsect2info>
+     <date>2002-04-19</date>
+    </refsect2info>
+    <title>
+     Outputs
+    </title>
+    <para>
+
+     <variablelist>
+      <varlistentry>
+       <term><computeroutput>ALTER</computeroutput></term>
+       <listitem>
+        <para>
+     Message returned from trigger renaming.
+        </para>
+       </listitem>
+      </varlistentry>
+
+      <varlistentry>
+       <term><computeroutput>ERROR</computeroutput></term>
+       <listitem>
+        <para>
+     Message returned if trigger is not available, or new name is a duplicate of another existing trigger on the
table.
+        </para>
+       </listitem>
+      </varlistentry>
+     </variablelist>
+    </para>
+   </refsect2>
+  </refsynopsisdiv>
+
+  <refsect1 id="R1-SQL-ALTERTRIGGER-1">
+   <refsect1info>
+    <date>2002-04-19</date>
+   </refsect1info>
+   <title>
+    Description
+   </title>
+   <para>
+    <command>ALTER TRIGGER</command> changes the definition of an existing trigger.
+    The <literal>RENAME</literal> clause causes the name of a trigger on the given table
+    to change without otherwise changing the trigger definition.
+   </para>
+
+   <para>
+    You must own the table on which the trigger acts in order to change its properties.
+   </para>
+
+   <refsect2 id="R2-SQL-ALTERTRIGGER-3">
+    <refsect2info>
+     <date>2002-04-19</date>
+    </refsect2info>
+    <title>
+     Notes
+    </title>
+    <para>
+     Refer to <command>CREATE TRIGGER</command> for a further description
+     of valid arguments.
+    </para>
+   </refsect2>
+  </refsect1>
+
+  <refsect1 id="R1-SQL-ALTERTRIGGER-2">
+   <title>
+    Usage
+   </title>
+   <para>
+    To rename an existing trigger:
+    <programlisting>
+ ALTER TRIGGER emp_stamp ON emp RENAME TO emp_track_chgs;
+    </programlisting>
+   </para>
+  </refsect1>
+
+  <refsect1 id="R1-SQL-ALTERTRIGGER-3">
+   <title>
+    Compatibility
+   </title>
+
+   <refsect2 id="R2-SQL-ALTERTRIGGER-4">
+    <refsect2info>
+     <date>2002-04-19</date>
+    </refsect2info>
+    <title>SQL92</title>
+    <para>
+     The clause to rename triggers is a
+     <productname>PostgreSQL</productname> extension from SQL92.
+    </para>
+   </refsect2>
+  </refsect1>
+ </refentry>
+
+ <!-- Keep this comment at the end of the file
+ Local variables:
+ mode: sgml
+ sgml-omittag:nil
+ sgml-shorttag:t
+ sgml-minimize-attributes:nil
+ sgml-always-quote-attributes:t
+ sgml-indent-step:1
+ sgml-indent-data:t
+ sgml-parent-document:nil
+ sgml-default-dtd-file:"../reference.ced"
+ sgml-exposed-tags:nil
+ sgml-local-catalogs:"/usr/lib/sgml/catalog"
+ sgml-local-ecat-files:nil
+ End:
+ -->
diff -cNr pgsql.cvs.orig/doc/src/sgml/ref/create_trigger.sgml pgsql/doc/src/sgml/ref/create_trigger.sgml
*** pgsql.cvs.orig/doc/src/sgml/ref/create_trigger.sgml    Fri Apr 19 21:20:22 2002
--- pgsql/doc/src/sgml/ref/create_trigger.sgml    Fri Apr 19 21:41:52 2002
***************
*** 298,303 ****
--- 298,304 ----

    <simplelist type="inline">
     <member><xref linkend="sql-createfunction"></member>
+    <member><xref linkend="sql-altertrigger"></member>
     <member><xref linkend="sql-droptrigger"></member>
     <member><citetitle>PostgreSQL Programmer's Guide</citetitle></member>
    </simplelist>
diff -cNr pgsql.cvs.orig/doc/src/sgml/reference.sgml pgsql/doc/src/sgml/reference.sgml
*** pgsql.cvs.orig/doc/src/sgml/reference.sgml    Fri Apr 19 21:20:22 2002
--- pgsql/doc/src/sgml/reference.sgml    Fri Apr 19 21:38:01 2002
***************
*** 49,54 ****
--- 49,55 ----
     &alterDatabase;
     &alterGroup;
     &alterTable;
+    &alterTrigger;
     &alterUser;
     &analyze;
     &begin;