2 doc/src/sgml/ref/drop_event_trigger.sgml
3 PostgreSQL documentation
6 <refentry id="SQL-DROPEVENTTRIGGER">
8 <refentrytitle>DROP EVENT TRIGGER</refentrytitle>
9 <manvolnum>7</manvolnum>
10 <refmiscinfo>SQL - Language Statements</refmiscinfo>
14 <refname>DROP EVENT TRIGGER</refname>
15 <refpurpose>remove an event trigger</refpurpose>
18 <indexterm zone="sql-dropeventtrigger">
19 <primary>DROP EVENT TRIGGER</primary>
24 DROP EVENT TRIGGER [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> [ CASCADE | RESTRICT ]
29 <title>Description</title>
32 <command>DROP EVENT TRIGGER</command> removes an existing event trigger.
33 To execute this command, the current user must be the owner of the event
39 <title>Parameters</title>
44 <term><literal>IF EXISTS</literal></term>
47 Do not throw an error if the event trigger does not exist. A notice
48 is issued in this case.
54 <term><replaceable class="PARAMETER">name</replaceable></term>
57 The name of the event trigger to remove.
63 <term><literal>CASCADE</literal></term>
66 Automatically drop objects that depend on the trigger.
72 <term><literal>RESTRICT</literal></term>
75 Refuse to drop the trigger if any objects depend on it. This is
83 <refsect1 id="sql-dropeventtrigger-examples">
84 <title>Examples</title>
87 Destroy the trigger <literal>snitch</literal>:
90 DROP EVENT TRIGGER snitch;
91 </programlisting></para>
94 <refsect1 id="sql-dropeventtrigger-compatibility">
95 <title>Compatibility</title>
98 There is no <command>DROP EVENT TRIGGER</command> statement in the
105 <title>See Also</title>
107 <simplelist type="inline">
108 <member><xref linkend="sql-createeventtrigger"></member>
109 <member><xref linkend="sql-altereventtrigger"></member>