From e487979de50083659396a1e9a41c3bf502027cd2 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Wed, 1 Oct 2025 21:18:32 +0000 Subject: [PATCH] The FOLLOW_OBSERVERS.FOID cannot change --- db/schemas/lib/triggers/create/follow_observers.m4 | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/db/schemas/lib/triggers/create/follow_observers.m4 b/db/schemas/lib/triggers/create/follow_observers.m4 index 94257c8..f55c3f9 100644 --- a/db/schemas/lib/triggers/create/follow_observers.m4 +++ b/db/schemas/lib/triggers/create/follow_observers.m4 @@ -34,6 +34,11 @@ CREATE OR REPLACE FUNCTION follow_observers_func () -- AGPL_notice(` --', `2025', `The Meme Factory, Inc., www.karlpinc.com') + IF TG_OP = 'UPDATE' THEN + -- Allowing the FOID to change makes life too complicated. + cannot_change(`FOLLOW_OBSERVERS', `FOID') + END IF; + changequote({,})dnl person_active({FOLLOW_OBSERVERS}, {OBS_BRec}, {'Key (FOID) = (' -- 2.34.1