maintenance/postgres/archives/patch-page_deleted.sql

   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
   9 CREATE TRIGGER page_deleted AFTER DELETE ON page
  10   FOR EACH ROW EXECUTE PROCEDURE page_deleted();
  11