From 7295eb9c6c7ce59a19bfb5e19b7cd9dcffe8c834 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Tue, 9 Jun 2026 23:28:42 +0000 Subject: [PATCH] Validate ARRIVALS_A.Recorder and Observer2 against PEOPLE.Active --- db/schemas/lib/triggers/create/arrivals_a.m4 | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) diff --git a/db/schemas/lib/triggers/create/arrivals_a.m4 b/db/schemas/lib/triggers/create/arrivals_a.m4 index e71df24..6b06c70 100644 --- a/db/schemas/lib/triggers/create/arrivals_a.m4 +++ b/db/schemas/lib/triggers/create/arrivals_a.m4 @@ -103,6 +103,24 @@ CREATE OR REPLACE FUNCTION arrivals_a_func () END; END IF; + changequote({,})dnl + person_active({ARRIVALS_A}, {Recorder}, + {'Key (EID = (' + || NEW.eid + || '): Value (Cycle) = (' + || NEW.cycle + || ')'}) + changequote(`,')dnl + + changequote({,})dnl + person_active({ARRIVALS_A}, {Observer2}, + {'Key (EID = (' + || NEW.eid + || '): Value (Cycle) = (' + || NEW.cycle + || ')'}) + changequote(`,')dnl + RETURN NULL; END; $$; -- 2.34.1