Postgresql 中文操作指南
Synopsis
ALTER TRIGGER name ON table_name RENAME TO new_name
ALTER TRIGGER name ON table_name [ NO ] DEPENDS ON EXTENSION extension_nameDescription
ALTER TRIGGER 更改现有触发器的属性。
ALTER TRIGGER changes properties of an existing trigger.
RENAME 子句更改给定触发器的名称，而不更改触发器定义。如果触发器所在表是分区表，则分区中的相应克隆触发器也会被重命名。
The RENAME clause changes the name of the given trigger without otherwise changing the trigger definition. If the table that the trigger is on is a partitioned table, then corresponding clone triggers in the partitions are renamed too.
DEPENDS ON EXTENSION 子句将触发器标记为依赖于扩展，以便在删除扩展时自动删除触发器。
The DEPENDS ON EXTENSION clause marks the trigger as dependent on an extension, such that if the extension is dropped, the trigger will automatically be dropped as well.
你必须拥有触发器执行操作的表的权限才能更改其属性。
You must own the table on which the trigger acts to be allowed to change its properties.
Parameters
-
name
-
The name of an existing trigger to alter.
-
-
table_name
-
The name of the table on which this trigger acts.
-
-
new_name
-
The new name for the trigger.
-
-
extension_name
-
The name of the extension that the trigger is to depend on (or no longer dependent on, if NO is specified). A trigger that’s marked as dependent on an extension is automatically dropped when the extension is dropped.
-
Notes
暂时启用或禁用触发器的功能由 ALTER TABLE 提供，而不是由 ALTER TRIGGER 提供，因为 ALTER TRIGGER 没有便捷的方式来同时表达启用或禁用表的所有触发器的选项。
The ability to temporarily enable or disable a trigger is provided by ALTER TABLE, not by ALTER TRIGGER, because ALTER TRIGGER has no convenient way to express the option of enabling or disabling all of a table’s triggers at once.
Examples
重命名现有触发器：
To rename an existing trigger:
ALTER TRIGGER emp_stamp ON emp RENAME TO emp_track_chgs;将触发器标记为依赖于扩展：
To mark a trigger as being dependent on an extension:
ALTER TRIGGER emp_stamp ON emp DEPENDS ON EXTENSION emplib;Compatibility
ALTER TRIGGER 是 SQL 标准的 PostgreSQL 扩展。
ALTER TRIGGER is a PostgreSQL extension of the SQL standard.