From a51b8f2c17f191f0e4cfcb6eaadadfa8f000d6cc Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Tue, 9 Jun 2026 23:31:45 +0000 Subject: [PATCH] Fire comm_memb_log_trigger after INSERT as well as update --- db/schemas/lib/triggers/create/comm_memb_log.m4 | 14 ++++++++------ 1 file changed, 8 insertions(+), 6 deletions(-) diff --git a/db/schemas/lib/triggers/create/comm_memb_log.m4 b/db/schemas/lib/triggers/create/comm_memb_log.m4 index 078ac3e..8793100 100644 --- a/db/schemas/lib/triggers/create/comm_memb_log.m4 +++ b/db/schemas/lib/triggers/create/comm_memb_log.m4 @@ -1,4 +1,4 @@ -dnl Copyright (C) 2015 The Meme Factory, Inc. http://www.karlpinc.com/ +dnl Copyright (C) 2025, 2026 The Meme Factory, Inc. http://www.karlpinc.com/ dnl dnl This program is free software: you can redistribute it and/or modify it dnl under the terms of the GNU Affero General Public License as published by @@ -30,13 +30,15 @@ CREATE OR REPLACE FUNCTION comm_memb_log_func () sdb_function_set_search_path AS $$ BEGIN - -- Function for comm_memb_log update trigger + -- Function for comm_memb_log insert and update triggers -- - -- AGPL_notice(` --', `2025', + -- AGPL_notice(` --', `2025, 2026', `The Meme Factory, Inc., www.karlpinc.com') - -- Allowing the CommMLID to change makes life too complicated. - cannot_change(`COMM_MEMB_LOG', `CommMLID') + IF TG_OP = 'INSERT' THEN + -- Allowing the CommMLID to change makes life too complicated. + cannot_change(`COMM_MEMB_LOG', `CommMLID') + END IF; RETURN NULL; END; @@ -45,6 +47,6 @@ $$; RAISE INFO 'comm_memb_log_trigger'; CREATE TRIGGER comm_memb_log_trigger - AFTER UPDATE + AFTER INSERT OR UPDATE ON comm_memb_log FOR EACH ROW EXECUTE PROCEDURE comm_memb_log_func(); -- 2.34.1