Changeset 2407bbfb4b4102e4faceeca0dd9510862b01c344

Show
Ignore:
Timestamp:
10/02/09 19:58:40 (4 years ago)
Author:
Denish Patel <denish@omniti.com>
git-committer:
Denish Patel <denish@omniti.com> 1254513520 +0000
git-parent:

[3b2f82c766ae4877378154731023a27447192e2b]

git-author:
Denish Patel <denish@omniti.com> 1254513520 +0000
Message:

Trigger function noit.update_mns_via_metric_tag

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • sql/sprocs/noit.update_mns_via_metric_tag.sql

    r3b2f82c r2407bbf  
    11-- formerly stratcon.trig_update_tsvector_from_metric_tags 
     2 
     3CREATE OR REPLACE FUNCTION noit.update_mns_via_metric_tag() 
     4  RETURNS trigger AS 
     5$BODY$ 
     6DECLARE 
     7BEGIN 
     8    UPDATE noit.metric_name_summary SET ts_search_all=stratcon.metric_name_summary_tsvector(NEW.sid,NEW.metric_name,metric_type) 
     9    where sid=NEW.sid and metric_name=NEW.metric_name; 
     10   RETURN NEW; 
     11END 
     12$BODY$ 
     13  LANGUAGE 'plpgsql'  SECURITY DEFINER; 
     14  
     15GRANT EXECUTE ON FUNCTION noit.update_mns_via_metric_tag() TO stratcon;