|
Revision f0400f824c10ceac576427c5023429506384cd8a, 326 bytes
(checked in by Robert Treat <robert@omniti.com>, 7 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 |
|
|---|
