Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
ALTER TRIGGER modifies a .
| Parameter | Description |
|---|---|
IF EXISTS | Rename the trigger only if the table and trigger exist. If the table or trigger does not exist, the statement succeeds without renaming a trigger. |
trigger_name | The current name of the trigger. |
table_name | The name of the table associated with the trigger. |
trigger_new_name | The new name of the trigger. |
ALTER TRIGGER ... IF EXISTS is a CockroachDB extension of the PostgreSQL syntax, which does not accept IF EXISTS for ALTER TRIGGER.$ cockroach demo
CREATE FUNCTION update_timestamp()
RETURNS TRIGGER AS $$
BEGIN
RAISE NOTICE 'Current timestamp: %', now();
RETURN NEW;
END;
$$ LANGUAGE PLpgSQL;
CREATE TRIGGER log_update_timestamp
AFTER UPDATE ON users
FOR EACH ROW
EXECUTE FUNCTION update_timestamp();
ALTER TRIGGER log_update_timestamp ON users RENAME TO log_updates;
SHOW TRIGGERS FROM users;
trigger_name | enabled
---------------+----------
log_updates | t
(1 row)