Debian Codegraph @

doc/src/sgml/ref/alter_event_trigger.sgml

raw
1 <!--
2 doc/src/sgml/ref/alter_event_trigger.sgml
3 PostgreSQL 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>
24 ALTER EVENT TRIGGER <replaceable class="parameter">name</replaceable> DISABLE
25 ALTER EVENT TRIGGER <replaceable class="parameter">name</replaceable> ENABLE [ REPLICA | ALWAYS ]
26 ALTER EVENT TRIGGER <replaceable class="parameter">name</replaceable> OWNER TO { <replaceable class="parameter">new_owner</replaceable> | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
27 ALTER 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 ]</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>