1<!-- 2doc/src/sgml/ref/alter_event_trigger.sgml 3PostgreSQL documentation 4--> 5 6<refentry id="sql-altereventtrigger"> 7 <indexterm zone="sql-altereventtrigger"> 8 <primary>ALTER EVENT TRIGGER</primary> 9 </indexterm> 10 11 <refmeta> 12 <refentrytitle>ALTER EVENT TRIGGER</refentrytitle> 13 <manvolnum>7</manvolnum> 14 <refmiscinfo>SQL - Language Statements</refmiscinfo> 15 </refmeta> 16 17 <refnamediv> 18 <refname>ALTER EVENT TRIGGER</refname> 19 <refpurpose>change the definition of an event trigger</refpurpose> 20 </refnamediv> 21 22 <refsynopsisdiv> 23<synopsis> 24ALTER EVENT TRIGGER <replaceable class="parameter">name</replaceable> DISABLE 25ALTER EVENT TRIGGER <replaceable class="parameter">name</replaceable> ENABLE [ REPLICA | ALWAYS ] 26ALTER EVENT TRIGGER <replaceable class="parameter">name</replaceable> OWNER TO { <replaceable class="parameter">new_owner</replaceable> | CURRENT_USER | SESSION_USER } 27ALTER EVENT TRIGGER <replaceable class="parameter">name</replaceable> RENAME TO <replaceable class="parameter">new_name</replaceable> 28</synopsis> 29 </refsynopsisdiv> 30 31 <refsect1> 32 <title>Description</title> 33 34 <para> 35 <command>ALTER EVENT TRIGGER</command> changes properties of an 36 existing event trigger. 37 </para> 38 39 <para> 40 You must be superuser to alter an event trigger. 41 </para> 42 </refsect1> 43 44 <refsect1> 45 <title>Parameters</title> 46 47 <variablelist> 48 <varlistentry> 49 <term><replaceable class="parameter">name</replaceable></term> 50 <listitem> 51 <para> 52 The name of an existing trigger to alter. 53 </para> 54 </listitem> 55 </varlistentry> 56 57 <varlistentry> 58 <term><replaceable class="parameter">new_owner</replaceable></term> 59 <listitem> 60 <para> 61 The user name of the new owner of the event trigger. 62 </para> 63 </listitem> 64 </varlistentry> 65 66 <varlistentry> 67 <term><replaceable class="parameter">new_name</replaceable></term> 68 <listitem> 69 <para> 70 The new name of the event trigger. 71 </para> 72 </listitem> 73 </varlistentry> 74 75 <varlistentry> 76 <term><literal>DISABLE</literal>/<literal>ENABLE [ REPLICA | ALWAYS ] TRIGGER</literal></term> 77 <listitem> 78 <para> 79 These forms configure the firing of event triggers. A disabled trigger 80 is still known to the system, but is not executed when its triggering 81 event occurs. See also <xref linkend="guc-session-replication-role"/>. 82 </para> 83 </listitem> 84 </varlistentry> 85 </variablelist> 86 </refsect1> 87 88 <refsect1 id="sql-alterventtrigger-compatibility"> 89 <title>Compatibility</title> 90 91 <para> 92 There is no <command>ALTER EVENT TRIGGER</command> statement in the 93 SQL standard. 94 </para> 95 </refsect1> 96 97 <refsect1> 98 <title>See Also</title> 99 100 <simplelist type="inline"> 101 <member><xref linkend="sql-createeventtrigger"/></member> 102 <member><xref linkend="sql-dropeventtrigger"/></member> 103 </simplelist> 104 </refsect1> 105</refentry> 106