maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_rw_insert_alert2notviewed()
Parameters
Name
Type
Mode
Definition
/* Replicate alerts to the alert_notviewed table */ DECLARE err_msg varchar; err_detail varchar; err_hint varchar; BEGIN IF TG_OP = 'INSERT' THEN INSERT INTO alert_notviewed SELECT NEW.*; 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;