Show
Ignore:
Timestamp:
10/21/09 15:50:40 (4 years ago)
Author:
Robert Treat <robert@omniti.com>
git-committer:
Robert Treat <robert@omniti.com> 1256140240 +0000
git-parent:

[e7461293e27d140464ef3333137cbe5621df7fc3]

git-author:
Robert Treat <robert@omniti.com> 1256140240 +0000
Message:

is it as easy as using the right table names?

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • sql/sprocs/stratcon.rollup_metric_numeric_5m.sql

    re746129 r32ddc52  
    5151    IF v_min_whence <= v_max_rollup_5 THEN 
    5252-- do we still need this? i think "we" dont, but maybe some people do?  
    53        DELETE FROM rollup_matrix_numeric_5m  
     53       DELETE FROM metric_numeric_rollup_5m 
    5454           WHERE rollup_time = v_min_whence; 
    5555    END IF; 
     
    5959        v_offset := ( 12*(extract('hour' from v_min_whence))+floor(extract('minute' from v_min_whence)/5) );    
    6060 
    61         SELECT * FROM rollup_matrix_numeric_5m WHERE rollup_time = v_info.rollup_time AND sid=v_info.sid AND name=v_info.name INTO v_rec; 
     61        SELECT * FROM metric_numeric_rollup_5m WHERE rollup_time = v_info.rollup_time AND sid=v_info.sid AND name=v_info.name INTO v_rec; 
    6262        IF NOT FOUND THEN  
    63                 SELECT * FROM init_rollup_matrix_numeric_5m() INTO v_rec;  
     63                SELECT * FROM stratcon.init_metric_numeric_rollup_5m() INTO v_rec;  
    6464                v_init := true;  
    6565        END IF; 
     
    7373 
    7474        IF v_init THEN 
    75                 INSERT INTO rollup_matrix_numeric_5m (sid,name,rollup_time,count_rows,avg_value,counter_dev) 
     75                INSERT INTO metric_numeric_rollup_5m (sid,name,rollup_time,count_rows,avg_value,counter_dev) 
    7676                        VALUES (v_rec.sid,v_rec.name,v_rec.rollup_time,v_rec.count_rows,v_rec.avg_value,v_rec.counter_dev);  
    7777        ELSE 
    78                 UPDATE rollup_matrix_numeric_5m SET (count_rows,avg_value,counter_dev)  
     78                UPDATE metric_numeric_rollup_5m SET (count_rows,avg_value,counter_dev)  
    7979                        = (v_rec.count_rows,v_rec.avg_value,v_rec.counter_dev) 
    8080                        WHERE rollup_time = v_info.rollup_time  AND sid = v_info.sid  AND name = v_info.name;