root/sql/sprocs/noit.update_mns_via_check_tag.sql

Revision f0400f824c10ceac576427c5023429506384cd8a, 392 bytes (checked in by Robert Treat <robert@omniti.com>, 5 years ago)

trigger function updates for metric name summary management

  • Property mode set to 100644
Line 
1 -- formerly stratcon.trig_update_tsvector_from_check_tags()
2
3 set search_path = noit, pg_catalog;
4
5 CREATE OR REPLACE FUNCTION update_mns_via_check_tag()
6 RETURNS trigger AS
7 $BODY$
8 BEGIN
9     UPDATE metric_name_summary SET fts_data=stratcon.metric_name_summary_compile_fts_data(NEW.sid,metric_name,metric_type) WHERE sid=NEW.sid;
10     RETURN NEW;
11 END
12 $BODY$
13 LANGUAGE 'plpgsql'
14 SECURITY DEFINER;
15
Note: See TracBrowser for help on using the browser.