ALTER EVENT TRIGGER

Function

ALTER EVENT TRIGGER modifies an event trigger.

Precautions

Only the system administrator or super user has the permission to modify event triggers.

Syntax

ALTER EVENT TRIGGER name DISABLE
ALTER EVENT TRIGGER name ENABLE [ REPLICA | ALWAYS ]
ALTER EVENT TRIGGER name OWNER TO { new_owner | CURRENT_USER | SESSION_USER }
ALTER EVENT TRIGGER name RENAME TO new_name

Parameter Description

• name

  Specifies the name of the event trigger to be modified.

  Value range: all existing event triggers.

• new_name

  Specifies the new name after modification.

  Value range: strings that comply with the identifier naming convention. A value contains a maximum of 63 characters and cannot be the same as other event triggers on the same table.

Examples

For details, see Examples in CREATE EVENT TRIGGER.

Helpful Links

CREATE EVENT TRIGGER and DROP EVENT TRIGGER