Login Register

DROP EVENT TRIGGER

Name

DROP EVENT TRIGGER -- remove an event trigger

Synopsis

DROP EVENT TRIGGER [ IF EXISTS ] name [ CASCADE | RESTRICT ]

Description

DROP EVENT TRIGGER removes an existing event trigger. To execute this command, the current user must be the owner of the event trigger.

Parameters

IF EXISTS: Do not throw an error if the event trigger does not exist. A notice is issued in this case.
name: The name of the event trigger to remove.
CASCADE: Automatically drop objects that depend on the trigger, and in turn all objects that depend on those objects (see Section 5.13).
RESTRICT: Refuse to drop the trigger if any objects depend on it. This is the default.

Examples

Destroy the trigger snitch:

DROP EVENT TRIGGER snitch;

Compatibility

There is no DROP EVENT TRIGGER statement in the SQL standard.

See Also

CREATE EVENT TRIGGER, ALTER EVENT TRIGGER

Prev		Next
DROP DOMAIN	Up	DROP EXTENSION

Links:

https://www.postgresql.org/docs/9.6/static/sql-dropeventtrigger.html

doc_PostgreSQL

2016-10-12 11:33:08

Comments

Leave a Comment

Please login to continue.

Popular Articles

Evented#trigger() trigger (name, args) public Defined in packages/ember-runtime/lib/mixins/evented.js:104 Triggers a named event for the object. Any additional arg

CREATE EVENT TRIGGER NameCREATE EVENT TRIGGER -- define a new event trigger Synopsis CREATE EVENT TRIGGER name ON event [ WHEN filter_variable IN (filter_va

Event Trigger Functions PostgreSQL provides these helper functions to retrieve information from event triggers. For more information about event triggers, see Chapter 38. 9

base\Event trigger() trigger() public static method Triggers a class-level event. This method will cause invocation of event handlers that are attached to the named e

ALTER EVENT TRIGGER NameALTER EVENT TRIGGER -- change the definition of an event trigger Synopsis ALTER EVENT TRIGGER name DISABLE ALTER EVENT TRIGGER name ENABLE