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 ();