[Summary view] [Print] [Text view]

   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