Show
Ignore:
Timestamp:
05/21/08 20:41:30 (6 years ago)
Author:
Denish Patel <denish@omniti.com>
git-committer:
Denish Patel <denish@omniti.com> 1211402490 +0000
git-parent:

[a2c8a40a569ad8bc6677c21303849d5844ce5436]

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

better handling NOTICE for running job.

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • sql/schema.sql

    ra2c8a40 r3b875de  
    415415       RAISE EXCEPTION '%', SQLERRM; 
    416416    WHEN OTHERS THEN 
    417       UPDATE stratcon.rollup_runner SET RUNNER = '' WHERE ROLLUP_TABLE= 'rollup_matrix_numeric_5m'; 
    418       RAISE NOTICE '%', SQLERRM; 
     417         RAISE NOTICE '%', SQLERRM; 
    419418END 
    420419$$ LANGUAGE plpgsql; 
     
    519518       RAISE EXCEPTION '%', SQLERRM; 
    520519    WHEN OTHERS THEN 
    521       UPDATE stratcon.rollup_runner SET RUNNER = '' WHERE ROLLUP_TABLE= 'rollup_matrix_numeric_20m'; 
    522520      RAISE NOTICE '%', SQLERRM; 
    523521END 
     
    619617       RAISE EXCEPTION '%', SQLERRM; 
    620618    WHEN OTHERS THEN 
    621       UPDATE stratcon.rollup_runner SET RUNNER = '' WHERE ROLLUP_TABLE= 'rollup_matrix_numeric_60m'; 
    622619      RAISE NOTICE '%', SQLERRM; 
    623620END 
     
    718715       RAISE EXCEPTION '%', SQLERRM; 
    719716    WHEN OTHERS THEN 
    720        UPDATE stratcon.rollup_runner SET RUNNER = '' WHERE ROLLUP_TABLE= 'rollup_matrix_numeric_6hours'; 
    721717       RAISE NOTICE '%', SQLERRM; 
    722718END 
     
    819815      RAISE EXCEPTION '%', SQLERRM; 
    820816    WHEN OTHERS THEN 
    821       UPDATE stratcon.rollup_runner set runner = '' where rollup_table = 'rollup_matrix_numeric_12hours'; 
    822817      RAISE NOTICE '%', SQLERRM; 
    823818END