diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2012-12-11 19:28:31 -0500 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2012-12-11 19:28:31 -0500 |
| commit | cd3413ec3683918c9cb9cfb39ae5b2c32f231e8b (patch) | |
| tree | d1cb0ff4a854646f9fb8b7b4c31cbd20aa124b0b /doc/src | |
| parent | b19e4250b45e91c9cbdd18d35ea6391ab5961c8d (diff) | |
| download | postgresql-cd3413ec3683918c9cb9cfb39ae5b2c32f231e8b.tar.gz postgresql-cd3413ec3683918c9cb9cfb39ae5b2c32f231e8b.zip | |
Disable event triggers in standalone mode.
Per discussion, this seems necessary to allow recovery from broken event
triggers, or broken indexes on pg_event_trigger.
Dimitri Fontaine
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/create_event_trigger.sgml | 11 |
1 files changed, 9 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/create_event_trigger.sgml b/doc/src/sgml/ref/create_event_trigger.sgml index 08894b22cfb..040df118153 100644 --- a/doc/src/sgml/ref/create_event_trigger.sgml +++ b/doc/src/sgml/ref/create_event_trigger.sgml @@ -108,7 +108,14 @@ CREATE EVENT TRIGGER <replaceable class="PARAMETER">name</replaceable> <title>Notes</title> <para> - To create a trigger on a event, the user must be superuser. + Only superusers can create event triggers. + </para> + + <para> + Event triggers are disabled in single-user mode (see <xref + linkend="app-postgres">). If an erroneous event trigger disables the + database so much that you can't even drop the trigger, restart in + single-user mode and you'll be able to do that. </para> </refsect1> @@ -116,7 +123,7 @@ CREATE EVENT TRIGGER <replaceable class="PARAMETER">name</replaceable> <title>Examples</title> <para> - Forbid the execution of any <link linkend="ddl">ddl</link> command: + Forbid the execution of any <link linkend="ddl">DDL</link> command: <programlisting> CREATE OR REPLACE FUNCTION abort_any_command() |