Revision f0400f824c10ceac576427c5023429506384cd8a, 326 bytes
(checked in by Robert Treat <robert@omniti.com>, 9 years ago)
|
trigger function updates for metric name summary management
|
- Property mode set to
100644
|
Line | |
---|
1 |
set search_path = noit,pg_catalog; |
---|
2 |
|
---|
3 |
CREATE OR REPLACE FUNCTION update_mns_via_check_currently() |
---|
4 |
RETURNS trigger |
---|
5 |
AS $$ |
---|
6 |
BEGIN |
---|
7 |
UPDATE metric_name_summary SET fts_data=stratcon.metric_name_summary_compile_fts_data(sid, metric_name, metric_type) WHERE sid = NEW.sid; |
---|
8 |
RETURN NEW; |
---|
9 |
END |
---|
10 |
$$ |
---|
11 |
LANGUAGE plpgsql |
---|
12 |
SECURITY DEFINER |
---|
13 |
; |
---|
14 |
|
---|
15 |
|
---|