From 90a12492dd901d31d6ab9f51e2a9ccae7110ba47 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Mon, 8 Jun 2026 20:55:49 +0000 Subject: [PATCH] Change function and trigger names to reflect that they fire on insert --- db/schemas/lib/triggers/create/follows.m4 | 10 +++++----- db/schemas/lib/triggers/drop/follows.m4 | 2 +- 2 files changed, 6 insertions(+), 6 deletions(-) diff --git a/db/schemas/lib/triggers/create/follows.m4 b/db/schemas/lib/triggers/create/follows.m4 index b846791..91bc93f 100644 --- a/db/schemas/lib/triggers/create/follows.m4 +++ b/db/schemas/lib/triggers/create/follows.m4 @@ -573,8 +573,8 @@ CREATE OR REPLACE FUNCTION follows_func () $$; -RAISE INFO 'follows_commit_func'; -CREATE OR REPLACE FUNCTION follows_commit_func () +RAISE INFO 'follows_insert_commit_func'; +CREATE OR REPLACE FUNCTION follows_insert_commit_func () RETURNS trigger LANGUAGE plpgsql sdb_function_set_search_path @@ -666,10 +666,10 @@ CREATE TRIGGER follows_trigger ON follows FOR EACH ROW EXECUTE PROCEDURE follows_func(); -RAISE INFO 'follows_commit_trigger'; -CREATE CONSTRAINT TRIGGER follows_commit_trigger +RAISE INFO 'follows_insert_commit_trigger'; +CREATE CONSTRAINT TRIGGER follows_insert_commit_trigger AFTER INSERT ON follows DEFERRABLE INITIALLY DEFERRED FOR EACH ROW - EXECUTE PROCEDURE follows_commit_func(); + EXECUTE PROCEDURE follows_insert_commit_func(); diff --git a/db/schemas/lib/triggers/drop/follows.m4 b/db/schemas/lib/triggers/drop/follows.m4 index 06ecd58..d430660 100644 --- a/db/schemas/lib/triggers/drop/follows.m4 +++ b/db/schemas/lib/triggers/drop/follows.m4 @@ -21,4 +21,4 @@ dnl m4 includes include(`copyright.m4')dnl DROP FUNCTION IF EXISTS follows_func() CASCADE; -DROP FUNCTION IF EXISTS follows_commit_func() CASCADE; +DROP FUNCTION IF EXISTS follows_insert_commit_func() CASCADE; -- 2.34.1