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
Feedback