diff options
Diffstat (limited to 'doc/src/sgml/ref/drop_trigger.sgml')
| -rw-r--r-- | doc/src/sgml/ref/drop_trigger.sgml | 268 |
1 files changed, 123 insertions, 145 deletions
diff --git a/doc/src/sgml/ref/drop_trigger.sgml b/doc/src/sgml/ref/drop_trigger.sgml index f4b8d733e5..333b8b9e90 100644 --- a/doc/src/sgml/ref/drop_trigger.sgml +++ b/doc/src/sgml/ref/drop_trigger.sgml @@ -1,184 +1,162 @@ -<REFENTRY ID="SQL-DROPTRIGGER"> - <REFMETA> - <REFENTRYTITLE> +<refentry id="SQL-DROPTRIGGER"> + <refmeta> + <refentrytitle> DROP TRIGGER - </REFENTRYTITLE> - <REFMISCINFO>SQL - Language Statements</REFMISCINFO> - </REFMETA> - <REFNAMEDIV> - <REFNAME> + </refentrytitle> + <refmiscinfo>SQL - Language Statements</refmiscinfo> + </refmeta> + <refnamediv> + <refname> DROP TRIGGER - </REFNAME> - <REFPURPOSE> + </refname> + <refpurpose> Removes the definition of a trigger - </REFPURPOSE> + </refpurpose> </refnamediv> - <REFSYNOPSISDIV> - <REFSYNOPSISDIVINFO> - <DATE>1998-09-22</DATE> - </REFSYNOPSISDIVINFO> - <SYNOPSIS> -DROP TRIGGER <REPLACEABLE CLASS="PARAMETER">name</REPLACEABLE> ON <REPLACEABLE CLASS="PARAMETER">table</REPLACEABLE> - </SYNOPSIS> - - <REFSECT2 ID="R2-SQL-DROPTRIGGER-1"> - <REFSECT2INFO> - <DATE>1998-09-22</DATE> - </REFSECT2INFO> - <TITLE> + <refsynopsisdiv> + <refsynopsisdivinfo> + <date>1998-09-22</date> + </refsynopsisdivinfo> + <synopsis> +DROP TRIGGER <replaceable class="PARAMETER">name</replaceable> ON <replaceable class="PARAMETER">table</replaceable> + </synopsis> + + <refsect2 id="R2-SQL-DROPTRIGGER-1"> + <refsect2info> + <date>1998-09-22</date> + </refsect2info> + <title> Inputs - </TITLE> - <PARA> - </PARA> - <VARIABLELIST> - <VARLISTENTRY> - <TERM> - <REPLACEABLE CLASS="PARAMETER">name</REPLACEABLE> - </TERM> - <LISTITEM> - <PARA> - The name of an existing trigger. - </PARA> - </LISTITEM> - </VARLISTENTRY> - <VARLISTENTRY> - <TERM> - <REPLACEABLE CLASS="PARAMETER">table</REPLACEABLE> - </TERM> - <LISTITEM> - <PARA> - The name of a table. - </PARA> - </LISTITEM> - </VARLISTENTRY> - </variablelist> - </REFSECT2> - - <REFSECT2 ID="R2-SQL-DROPTRIGGER-2"> - <REFSECT2INFO> - <DATE>1998-09-22</DATE> - </REFSECT2INFO> - <TITLE> + </title> + <para> + + <variablelist> + <varlistentry> + <term><replaceable class="PARAMETER">name</replaceable></term> + <listitem> + <para> + The name of an existing trigger. + </para> + </listitem> + </varlistentry> + <varlistentry> + <term><replaceable class="PARAMETER">table</replaceable></term> + <listitem> + <para> + The name of a table. + </para> + </listitem> + </varlistentry> + </variablelist> + </para> + </refsect2> + + <refsect2 id="R2-SQL-DROPTRIGGER-2"> + <refsect2info> + <date>1998-09-22</date> + </refsect2info> + <title> Outputs - </TITLE> - <PARA> + </title> + <para> -<VARIABLELIST> - <VARLISTENTRY> - <TERM> - <ReturnValue>DROP</ReturnValue> - </TERM> - <LISTITEM> - <PARA> - The message returned if the trigger is successfully dropped. - </PARA> - </LISTITEM> - </VARLISTENTRY> - <VARLISTENTRY> - <TERM> - <ReturnValue>ERROR: DropTrigger: there is no trigger <REPLACEABLE CLASS="PARAMETER">name</REPLACEABLE> on relation "<replaceable class="parameter">table</replaceable>"</ReturnValue> - </TERM> - <LISTITEM> - <PARA> - This message occurs if the trigger specified does not exist. + <variablelist> + <varlistentry> + <term><computeroutput> +DROP + </computeroutput></term> + <listitem> + <para> + The message returned if the trigger is successfully dropped. </para> </listitem> </varlistentry> - </VARIABLELIST> + <varlistentry> + <term><computeroutput> +ERROR: DropTrigger: there is no trigger <replaceable class="PARAMETER">name</replaceable> on relation "<replaceable class="parameter">table</replaceable>" + </computeroutput></term> + <listitem> + <para> + This message occurs if the trigger specified does not exist. + </para> + </listitem> + </varlistentry> + </variablelist> </para> - </REFSECT2> - </REFSYNOPSISDIV> - - <REFSECT1 ID="R1-SQL-DROPTRIGGER-1"> - <REFSECT1INFO> - <DATE>1998-09-22</DATE> - </REFSECT1INFO> - <TITLE> + </refsect2> + </refsynopsisdiv> + + <refsect1 id="R1-SQL-DROPTRIGGER-1"> + <refsect1info> + <date>1998-09-22</date> + </refsect1info> + <title> Description - </TITLE> - <PARA> + </title> + <para> <command>DROP TRIGGER</command> will remove all references to an existing trigger definition. To execute this command the current user must be the owner of the trigger. - </PARA> - - <REFSECT2 ID="R2-SQL-DROPTRIGGER-3"> - <REFSECT2INFO> - <DATE>1998-09-22</DATE> - </REFSECT2INFO> - <TITLE> + </para> + + <refsect2 id="R2-SQL-DROPTRIGGER-3"> + <refsect2info> + <date>1998-09-22</date> + </refsect2info> + <title> Notes - </TITLE> - <PARA> + </title> + <para> <command>DROP TRIGGER</command> is a <productname>Postgres</productname> language extension. - </PARA> - <PARA> + </para> + <para> Refer to <command>CREATE TRIGGER</command> for information on how to create triggers. - </PARA> - </REFSECT2> + </para> + </refsect2> </refsect1> - <REFSECT1 ID="R1-SQL-DROPTRIGGER-2"> - <TITLE> + <refsect1 id="R1-SQL-DROPTRIGGER-2"> + <title> Usage - </TITLE> - <PARA> + </title> + <para> Destroy the <literal>if_dist_exists</literal> trigger - on table <literal>films</literal>: - </PARA> - <ProgramListing> + on table <literal>films</literal>: + + <programlisting> DROP TRIGGER if_dist_exists ON films; - </ProgramListing> - </REFSECT1> + </programlisting> + </para> + </refsect1> - <REFSECT1 ID="R1-SQL-DROPTRIGGER-3"> - <TITLE> + <refsect1 id="R1-SQL-DROPTRIGGER-3"> + <title> Compatibility - </TITLE> - <PARA> - </PARA> + </title> + <para> + </para> - <REFSECT2 ID="R2-SQL-DROPTRIGGER-4"> - <REFSECT2INFO> - <DATE>1998-09-22</DATE> - </REFSECT2INFO> - <TITLE> + <refsect2 id="R2-SQL-DROPTRIGGER-4"> + <refsect2info> + <date>1998-09-22</date> + </refsect2info> + <title> SQL92 - </TITLE> - <PARA> + </title> + <para> There is no <command>DROP TRIGGER</command> statement in - <acronym>SQL92</acronym>. - </PARA> + <acronym>SQL92</acronym>. + </para> </refsect2> </refsect1> -</REFENTRY> - -<!-- -<REPLACEABLE CLASS="PARAMETER"> -</REPLACEABLE> -<ReturnValue></ReturnValue> -<PARA> -</PARA> -<VARIABLELIST> -<VARLISTENTRY> -<TERM>• -</TERM> -<LISTITEM> -<PARA> -</PARA> -</LISTITEM> -</VARLISTENTRY> -</VARIABLELIST> -<PARA> -</PARA> ---> +</refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml -sgml-omittag:t +sgml-omittag:nil sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t |