From d5b932fcadde0d3ceeb566327c4078c214bdd639 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Wed, 22 Jul 2026 18:15:22 +0000 Subject: [PATCH] Use the correct macro symbol so BRECORD_NOTES will insert --- db/schemas/lib/triggers/create/brecord_notes.m4 | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/db/schemas/lib/triggers/create/brecord_notes.m4 b/db/schemas/lib/triggers/create/brecord_notes.m4 index a3440ab..310b7e6 100644 --- a/db/schemas/lib/triggers/create/brecord_notes.m4 +++ b/db/schemas/lib/triggers/create/brecord_notes.m4 @@ -39,7 +39,7 @@ CREATE OR REPLACE FUNCTION brecord_notes_func () cannot_change(`BRECORD_NOTES', `EID') END IF; - -- The EVENTS.Behavior must be sdb_brec_notes + -- The EVENTS.Behavior must be sdb_brec_note IF TG_OP = 'INSERT' THEN DECLARE -- EVENTS @@ -59,7 +59,7 @@ CREATE OR REPLACE FUNCTION brecord_notes_func () FROM events JOIN watches ON (watches.wid = events.wid) WHERE events.eid = NEW.eid - AND events.behavior <> 'sdb_brec_notes'; + AND events.behavior <> 'sdb_brec_note'; IF FOUND THEN RAISE EXCEPTION integrity_constraint_violation USING MESSAGE = 'Error on ' || TG_OP || ' of BRECORD_NOTES' -- 2.34.1