From 8b64e91539cf83383a856e5589d7356438597a1f Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Tue, 9 Jun 2026 20:53:18 +0000 Subject: [PATCH] Produce a consistent error message --- db/schemas/lib/triggers/create/groomings.m4 | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/db/schemas/lib/triggers/create/groomings.m4 b/db/schemas/lib/triggers/create/groomings.m4 index 578a940..a576b73 100644 --- a/db/schemas/lib/triggers/create/groomings.m4 +++ b/db/schemas/lib/triggers/create/groomings.m4 @@ -66,7 +66,8 @@ CREATE OR REPLACE FUNCTION groomings_func () JOIN follows ON (follows.fid = events.fid) LEFT OUTER JOIN roles ON (roles.eid = events.eid) WHERE events.eid = NEW.eid - AND events.behavior <> 'sdb_grooming'; + AND events.behavior <> 'sdb_grooming' + ORDER BY roles.participant; -- Consistent error message IF FOUND THEN RAISE EXCEPTION integrity_constraint_violation USING MESSAGE = 'Error on ' || TG_OP || ' of GROOMINGS' -- 2.34.1