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