From 19d6f492d0a9997ed01da9425b43c83f03bcc5cd Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Mon, 25 May 2026 16:55:46 +0000 Subject: [PATCH] Removed dropped GROOMINGS.Other column --- db/schemas/lib/triggers/create/roles.m4 | 4 +--- 1 file changed, 1 insertion(+), 3 deletions(-) diff --git a/db/schemas/lib/triggers/create/roles.m4 b/db/schemas/lib/triggers/create/roles.m4 index b0a6c04..02abff6 100644 --- a/db/schemas/lib/triggers/create/roles.m4 +++ b/db/schemas/lib/triggers/create/roles.m4 @@ -618,7 +618,6 @@ CREATE OR REPLACE FUNCTION roles_delete_commit_func () a_community follows.community%TYPE; -- GROOMINGS - a_other groomings.other%TYPE; a_initiator groomings.initiator%TYPE; a_terminator groomings.terminator%TYPE; a_problems groomings.problems%TYPE; @@ -790,8 +789,7 @@ CREATE OR REPLACE FUNCTION roles_delete_commit_func () IF FOUND THEN RAISE EXCEPTION integrity_constraint_violation USING MESSAGE = 'Error on DELETE of ROLES' - , DETAIL = 'The initiator and terminator of a grooming event,' - || ' and the other grooming partner, must all' + , DETAIL = 'The initiator and terminator of a grooming event must' || ' be one of the participants in the grooming event' || ': The deleted ROLES row is Key (PID) = (' || OLD.pid -- 2.34.1