maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_rw_deleteviewed_notviewed()
Parameters
Name
Type
Mode
Definition
/* Delete viewed alerts from not viewed table */ DECLARE err_msg varchar; err_detail varchar; err_hint varchar; BEGIN IF NEW.enabled = false THEN DELETE FROM alert_notviewed WHERE idalert = NEW.idalert; END IF; RETURN NEW; EXCEPTION WHEN OTHERS THEN GET STACKED DIAGNOSTICS err_msg = MESSAGE_TEXT, err_detail = PG_EXCEPTION_DETAIL, err_hint = PG_EXCEPTION_HINT; RAISE WARNING '% % %', err_msg,err_detail,err_hint; RETURN NEW; END;