Thread: doc patch for ALTER TRIGGER
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;
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
Patch applied. Thanks. --------------------------------------------------------------------------- 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