我正在尝试编写触发器,但遇到语法错误:
CREATE TRIGGER archive_domain_trig
AFTER UPDATE OF is_rejected ON pending_domains
FOR EACH ROW
WHEN (new.is_rejected is True)
EXECUTE PROCEDURE archive_domain_fun();错误:"OF“处或附近的语法错误
不仅如此,它还在"when“条件下给出错误。
CREATE TRIGGER archive_domain_trig
AFTER UPDATE ON pending_domains
FOR EACH ROW
WHEN (new.is_rejected is True)
EXECUTE PROCEDURE archive_domain_fun();提供:
错误:在"WHEN“或接近”WHEN“时出现语法错误。
select version();
"EnterpriseDB 8.3.0.116 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.1.0"这几乎类似于postgres的例子,有人能告诉我我做错了什么吗?
https://stackoverflow.com/questions/6006482
复制相似问题