From 64ad4e9594bffc68ed1b9c963fb6a8f453d26f61 Mon Sep 17 00:00:00 2001 From: Stevan Earl Date: Thu, 13 Aug 2026 10:38:15 -0700 Subject: [PATCH] Describe REPRO_STATES records correctly --- db/schemas/lib/triggers/create/repro_states.m4 | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/db/schemas/lib/triggers/create/repro_states.m4 b/db/schemas/lib/triggers/create/repro_states.m4 index df02b11..d3492ca 100644 --- a/db/schemas/lib/triggers/create/repro_states.m4 +++ b/db/schemas/lib/triggers/create/repro_states.m4 @@ -54,7 +54,7 @@ CREATE OR REPLACE FUNCTION repro_states_func () RAISE EXCEPTION integrity_constraint_violation USING MESSAGE = 'Error on ' || TG_OP || ' of REPRO_STATES' , DETAIL = 'An individual must be female to have' - || ' a swelling measurement' + || ' a reproductive state record' || ': Key (ReID) = (' || NEW.reid || '), Value (AnimID) = (' @@ -97,7 +97,7 @@ CREATE OR REPLACE FUNCTION repro_states_func () RAISE EXCEPTION integrity_constraint_violation USING MESSAGE = 'Error on ' || TG_OP || ' of REPRO_STATES' , DETAIL = 'An individual must be under study to have' - || ' a swelling measurement,' + || ' a reproductive state record,' || ' the REPRO_STATES.Date cannot be before' || ' BIOGRAPHY_DATA.EntryDate or after' || ' BIOGRAPHY_DATA.DepartDate' -- 2.34.1