From 6548a1ab0a0ff0375ad145052605a296877b192d Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Wed, 8 Oct 2025 23:37:10 +0000 Subject: [PATCH] Fix the ARRIVALS trigger to correct Cycle column name --- db/schemas/lib/triggers/create/arrivals.m4 | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/db/schemas/lib/triggers/create/arrivals.m4 b/db/schemas/lib/triggers/create/arrivals.m4 index 2dd859e..40698d9 100644 --- a/db/schemas/lib/triggers/create/arrivals.m4 +++ b/db/schemas/lib/triggers/create/arrivals.m4 @@ -144,14 +144,14 @@ CREATE OR REPLACE FUNCTION arrivals_func () ON (biography_data.animid = roles.participant) JOIN follows ON (follows.fid = events.fid) - WHERE roles.participant = NEW.animid + WHERE events.eid = NEW.eid -- Produce a consistent error message ORDER BY follows.date, follows.fid , events.start, events.stop, events.eid , roles.role, roles.pid; IF a_sex = 'sdb_female' THEN - IF NEW.code = 'sdb_male_swelling' THEN + IF NEW.cycle = 'sdb_male_swelling' THEN -- The sdb_male_swelling code (n/a) cannot be assigned to -- females. RAISE EXCEPTION integrity_constraint_violation USING @@ -189,7 +189,7 @@ CREATE OR REPLACE FUNCTION arrivals_func () || a_date || ')' , HINT = 'sdb_follow_age_hint'; - ELSIF NEW.code = 'sdb_adolescent_swelling' THEN + ELSIF NEW.cycle = 'sdb_adolescent_swelling' THEN -- The sdb_adolescent_swelling code (U) can only be assigned to -- adolescent females. -- 2.34.1