[Reconnoiter-devel] [reconnoiter commit] r1013 - branches/skeksis/sql/sprocs

svn-commit at lists.omniti.com svn-commit at lists.omniti.com
Fri Oct 23 16:02:13 EDT 2009


Author: robert
Date: 2009-10-23 16:02:12 -0400 (Fri, 23 Oct 2009)
New Revision: 1013

Modified:
   branches/skeksis/sql/sprocs/noit.mark_metric_numeric_rollup_buffer.sql
Log:
use config based interval names

Modified: branches/skeksis/sql/sprocs/noit.mark_metric_numeric_rollup_buffer.sql
===================================================================
--- branches/skeksis/sql/sprocs/noit.mark_metric_numeric_rollup_buffer.sql	2009-10-23 19:52:26 UTC (rev 1012)
+++ branches/skeksis/sql/sprocs/noit.mark_metric_numeric_rollup_buffer.sql	2009-10-23 20:02:12 UTC (rev 1013)
@@ -13,12 +13,12 @@
  
  v_whence_5:=date_trunc('H',NEW.WHENCE) + (round(extract('minute' from NEW.WHENCE)/5)*5) * '1 minute'::interval;
  
-   SELECT whence FROM noit.metric_numeric_rollup_queue WHERE whence=v_whence_5 and interval='5 minutes'
+   SELECT whence FROM noit.metric_numeric_rollup_queue WHERE whence=v_whence_5 and interval='5m'
      INTO v_whence;
      
    IF NOT FOUND THEN
       BEGIN
-       INSERT INTO  noit.metric_numeric_rollup_queue VALUES(v_whence_5,'5 minutes');
+       INSERT INTO  noit.metric_numeric_rollup_queue VALUES(v_whence_5,'5m');
        EXCEPTION
         WHEN UNIQUE_VIOLATION THEN
         -- do nothing 



More information about the Reconnoiter-devel mailing list