glints
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ensure_atleast_1_receiver_per_job()
Parameters
Name
Type
Mode
IN
Definition
DECLARE receiver_count integer; BEGIN SELECT count(*) INTO receiver_count FROM public."JobNotificationReceivers" WHERE "JobNotificationReceivers"."JobId" = OLD."JobId"; IF receiver_count <= 1 THEN RAISE EXCEPTION 'Each job must have atleast one Job Notification Receiver'; END IF; RETURN OLD; END;