From 15db51b790133e5f4c1783fad770dccd44aaf127 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Fri, 19 Jan 2024 14:22:13 +0000 Subject: [PATCH] Fix syntax error --- db/schemas/lib/triggers/create/comm_membs.m4 | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/db/schemas/lib/triggers/create/comm_membs.m4 b/db/schemas/lib/triggers/create/comm_membs.m4 index f4f6133..25f959f 100644 --- a/db/schemas/lib/triggers/create/comm_membs.m4 +++ b/db/schemas/lib/triggers/create/comm_membs.m4 @@ -46,7 +46,7 @@ CREATE OR REPLACE FUNCTION comm_membs_func () WHERE comm_membs.animid = NEW.animid AND comm_membs.startdate <= NEW.enddate AND comm_membs.enddate >= NEW.startdate - AND comm_membs.commmid <> NEW.comm_membs.commmid; + AND comm_membs.commmid <> NEW.commmid; IF FOUND THEN RAISE EXCEPTION integrity_constraint_violation USING MESSAGE = 'An individual may not be in more than one community' -- 2.34.1