maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_rw_maint_alert_trigger()
Parameters
Name
Type
Mode
Definition
DECLARE r record; BEGIN SET statement_timeout = '500 ms'; FOR r IN /* Get the list existing alert partitions that don't have the a_devicealert_keepcount trigger */ WITH q AS (SELECT pgc.relname,t.tgname FROM pg_class pgc LEFT JOIN pg_catalog.pg_trigger t ON (pgc.oid = t.tgrelid AND t.tgname = 'a_devicealert_keepcount') WHERE pgc.relname similar to 'alert_p\d{4}_\d{2}_\d{2}' ORDER BY 1) SELECT relname FROM q WHERE q.tgname IS NULL LOOP EXECUTE format('CREATE TRIGGER a_devicealert_keepcount AFTER INSERT OR UPDATE OF enabled ON %I FOR EACH ROW EXECUTE PROCEDURE ot_rw_devicealert_keepcount()', r.relname); END LOOP; EXCEPTION WHEN OTHERS THEN RAISE NOTICE '%,%', SQLSTATE, SQLERRM; END;