root/sql/sprocs/noit.update_mns_via_check_currently.sql

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

trigger function updates for metric name summary management

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