From a5ff80d32c8102008f91a987a5236dc38c3c473f Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Fri, 19 Jun 2026 00:07:04 +0000 Subject: [PATCH] Remove hard-coded value --- db/schemas/lib/triggers/create/roles.m4 | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/db/schemas/lib/triggers/create/roles.m4 b/db/schemas/lib/triggers/create/roles.m4 index c954779..d538a69 100644 --- a/db/schemas/lib/triggers/create/roles.m4 +++ b/db/schemas/lib/triggers/create/roles.m4 @@ -86,8 +86,9 @@ CREATE OR REPLACE FUNCTION roles_func () IF FOUND THEN RAISE EXCEPTION integrity_constraint_violation USING MESSAGE = 'Error on ' || TG_OP || ' of ROLES' - , DETAIL = 'An event with a (Behavior) = (sdb_other_species)' - || ' cannot be related to a chimpanzee; cannot' + , DETAIL = 'An event with a (Behavior) = (' + || a_behavior + || ') cannot be related to a chimpanzee; cannot' || ' have a related ROLES row' || ': Key (PID) = (' || NEW.pid -- 2.34.1