Show
Ignore:
Timestamp:
10/02/09 18:27:51 (9 years ago)
Author:
Denish Patel <denish@omniti.com>
git-committer:
Denish Patel <denish@omniti.com> 1254508071 +0000
git-parent:

[747802282ccab1d4eb70c32d900e96abd5af005d]

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

updated noit.update_mns_via_check_tag

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • sql/sprocs/noit.update_mns_via_check_tag.sql

    r7478022 r7bdcc13  
    11-- formerly stratcon.trig_update_tsvector_from_check_tags() 
     2 
     3CREATE OR REPLACE FUNCTION noit.update_mns_via_check_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,metric_name,metric_type) 
     9    where sid=NEW.sid; 
     10   RETURN NEW; 
     11END 
     12$BODY$ 
     13  LANGUAGE 'plpgsql'   SECURITY DEFINER; 
     14 
     15GRANT EXECUTE ON FUNCTION noit.update_mns_via_check_tag() TO stratcon;