Re: doc patch for ALTER TRIGGER

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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026