Re: doc patch for ALTER TRIGGER - Mailing list pgsql-patches

Your patch has been added to the PostgreSQL unapplied patches list at:

    http://candle.pha.pa.us/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

---------------------------------------------------------------------------


Joe Conway wrote:
> 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;

>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026