我正在 PGAdminIII 上创建一个触发器,想要删除在其他表中有外键的行。然而,我出现了语法错误,但找不到问题所在:
CREATE TRIGGER clienteDelete
BEFORE DELETE ON cliente
FOR EACH ROW
BEGIN
DELETE FROM contacto WHERE contacto.id = OLD.contacto_idcontacto;
END;
ERROR: syntax error at or near "BEGIN"
LINE 4: BEGIN
^
********** Error **********
ERROR: syntax error at or near "BEGIN"
SQL state: 42601
Character: 68
我不习惯Postgres上触发器的语法,但这是根据SQL标准所知道的。任何帮助将不胜感激。