| | 2 | CREATE OR REPLACE FUNCTION noit.update_mns_via_self() |
|---|
| | 3 | RETURNS trigger AS |
|---|
| | 4 | $BODY$ |
|---|
| | 5 | DECLARE |
|---|
| | 6 | BEGIN |
|---|
| | 7 | IF TG_OP != 'INSERT' THEN |
|---|
| | 8 | IF (NEW.metric_name <> OLD.metric_name) THEN |
|---|
| | 9 | UPDATE noit.metric_name_summary SET ts_search_all=stratcon.metric_name_summary_tsvector(NEW.sid,NEW.metric_name,NEW.metric_type) |
|---|
| | 10 | where sid=NEW.sid and metric_name=NEW.metric_name and metric_type = NEW.metric_type; |
|---|
| | 11 | END IF; |
|---|
| | 12 | ELSE |
|---|
| | 13 | UPDATE noit.metric_name_summary SET ts_search_all=stratcon.metric_name_summary_tsvector(NEW.sid,NEW.metric_name,NEW.metric_type) |
|---|
| | 14 | where sid=NEW.sid and metric_name=NEW.metric_name and metric_type = NEW.metric_type; |
|---|
| | 15 | END IF; |
|---|
| | 16 | RETURN NEW; |
|---|
| | 17 | END |
|---|
| | 18 | $BODY$ |
|---|
| | 19 | LANGUAGE 'plpgsql' SECURITY DEFINER; |
|---|
| | 20 | |
|---|
| | 21 | GRANT EXECUTE ON FUNCTION noit.update_mns_via_self() TO stratcon; |
|---|
