1 CREATE FUNCTION page_deleted() RETURNS TRIGGER LANGUAGE plpgsql
AS
4 DELETE FROM recentchanges
WHERE rc_namespace
= OLD.page_namespace
AND rc_title
= OLD.page_title
;
9 CREATE TRIGGER page_deleted
AFTER DELETE ON page
10 FOR EACH ROW EXECUTE PROCEDURE page_deleted();