Show
Ignore:
Timestamp:
10/02/09 20:05:41 (9 years ago)
Author:
Denish Patel <denish@omniti.com>
git-committer:
Denish Patel <denish@omniti.com> 1254513941 +0000
git-parent:

[2407bbfb4b4102e4faceeca0dd9510862b01c344]

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

Updated trigger functions related to metric_name_summary as we changed column name from ts_search_all to fts_data

Files:

Legend:

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

    r7bdcc13 rae19db0  
    66DECLARE 
    77BEGIN 
    8     UPDATE noit.metric_name_summary SET ts_search_all=stratcon.metric_name_summary_tsvector(NEW.sid,metric_name,metric_type) 
     8    UPDATE noit.metric_name_summary SET fts_data=stratcon.metric_name_summary_tsvector(NEW.sid,metric_name,metric_type) 
    99    where sid=NEW.sid; 
    1010   RETURN NEW;