patch-page_deleted.sql 299 B

123456789101112
  1. CREATE FUNCTION page_deleted() RETURNS TRIGGER LANGUAGE plpgsql AS
  2. $mw$
  3. BEGIN
  4. DELETE FROM recentchanges WHERE rc_namespace = OLD.page_namespace AND rc_title = OLD.page_title;
  5. RETURN NULL;
  6. END;
  7. $mw$;
  8. CREATE TRIGGER page_deleted AFTER DELETE ON page
  9. FOR EACH ROW EXECUTE PROCEDURE page_deleted();