3 SELECT evergreen.upgrade_deps_block_check('0925', :eg_version);
5 CREATE OR REPLACE FUNCTION evergreen.limit_oustl() RETURNS TRIGGER AS $oustl_limit$
7 -- Only keeps the most recent five settings changes.
8 DELETE FROM config.org_unit_setting_type_log WHERE field_name = NEW.field_name AND org = NEW.org AND date_applied NOT IN
9 (SELECT date_applied FROM config.org_unit_setting_type_log WHERE field_name = NEW.field_name AND org = NEW.org ORDER BY date_applied DESC LIMIT 4);
11 IF (TG_OP = 'UPDATE') THEN
13 ELSIF (TG_OP = 'INSERT') THEN
18 $oustl_limit$ LANGUAGE plpgsql;
20 DROP TRIGGER IF EXISTS limit_logs_oust ON config.org_unit_setting_type_log;
22 CREATE TRIGGER limit_logs_oust
23 BEFORE INSERT OR UPDATE ON config.org_unit_setting_type_log
24 FOR EACH ROW EXECUTE PROCEDURE limit_oustl();