CREATE OR REPLACE FUNCTION commit_log_update () RETURNS TRIGGER
AS '
BEGIN
   UPDATE latest_commits_ports
      SET commit_date = new.commit_date
    WHERE (latest_commits_ports.commit_log_id = new.id);

   UPDATE latest_commits
      SET commit_date = new.commit_date
    WHERE (latest_commits.commit_log_id = new.id);

   RETURN new;
END;'
LANGUAGE plpgsql;

  DROP TRIGGER commit_log_update on commit_log;
CREATE TRIGGER commit_log_update
AFTER UPDATE on commit_log
FOR EACH ROW
EXECUTE PROCEDURE commit_log_update ();