From ac2966263e5880cf9485414c2320919d84c9fbb5 Mon Sep 17 00:00:00 2001 From: Stevan Earl Date: Thu, 13 Aug 2026 10:49:49 -0700 Subject: [PATCH] Close values before related-table diagnostics --- db/schemas/lib/triggers/create/arrivals.m4 | 12 ++++++------ db/schemas/lib/triggers/create/biography_data.m4 | 16 ++++++++-------- db/schemas/lib/triggers/create/events.m4 | 2 +- db/schemas/lib/triggers/create/watches.m4 | 14 +++++++------- 4 files changed, 22 insertions(+), 22 deletions(-) diff --git a/db/schemas/lib/triggers/create/arrivals.m4 b/db/schemas/lib/triggers/create/arrivals.m4 index e6761c0..aa815ad 100644 --- a/db/schemas/lib/triggers/create/arrivals.m4 +++ b/db/schemas/lib/triggers/create/arrivals.m4 @@ -390,7 +390,7 @@ CREATE OR REPLACE FUNCTION arrivals_func () || a_pid || '), Value (ROLES.Role) = (' || a_role - || ': Key (BIOGRAPHY_DATA.AnimID) = (' + || '): Key (BIOGRAPHY_DATA.AnimID) = (' || a_animid || '): Value (BIOGRAPHY_DATA.Sex) = (' || a_sex @@ -442,7 +442,7 @@ CREATE OR REPLACE FUNCTION arrivals_func () || a_pid || '), Value (ROLES.Role) = (' || a_role - || ': Key (BIOGRAPHY_DATA.AnimID) = (' + || '): Key (BIOGRAPHY_DATA.AnimID) = (' || a_animid || '): Value (BIOGRAPHY_DATA.Sex) = (' || a_sex @@ -490,7 +490,7 @@ CREATE OR REPLACE FUNCTION arrivals_func () || a_pid || '), Value (ROLES.Role) = (' || a_role - || ': Key (BIOGRAPHY_DATA.AnimID) = (' + || '): Key (BIOGRAPHY_DATA.AnimID) = (' || a_animid || '): Value (BIOGRAPHY_DATA.Sex) = (' || a_sex @@ -541,7 +541,7 @@ CREATE OR REPLACE FUNCTION arrivals_func () || a_pid || '), Value (ROLES.Role) = (' || a_role - || ': Key (BIOGRAPHY_DATA.AnimID) = (' + || '): Key (BIOGRAPHY_DATA.AnimID) = (' || a_animid || '): Value (BIOGRAPHY_DATA.Sex) = (' || a_sex @@ -587,7 +587,7 @@ CREATE OR REPLACE FUNCTION arrivals_func () || a_pid || '), Value (ROLES.Role) = (' || a_role - || ': Key (BIOGRAPHY_DATA.AnimID) = (' + || '): Key (BIOGRAPHY_DATA.AnimID) = (' || a_animid || '): Value (BIOGRAPHY_DATA.Sex) = (' || a_sex @@ -632,7 +632,7 @@ CREATE OR REPLACE FUNCTION arrivals_func () || a_pid || '), Value (ROLES.Role) = (' || a_role - || ': Key (BIOGRAPHY_DATA.AnimID) = (' + || '): Key (BIOGRAPHY_DATA.AnimID) = (' || a_animid || '): Value (BIOGRAPHY_DATA.Sex) = (' || a_sex diff --git a/db/schemas/lib/triggers/create/biography_data.m4 b/db/schemas/lib/triggers/create/biography_data.m4 index 83e2916..fbbd394 100644 --- a/db/schemas/lib/triggers/create/biography_data.m4 +++ b/db/schemas/lib/triggers/create/biography_data.m4 @@ -467,7 +467,7 @@ CREATE OR REPLACE FUNCTION biography_data_func () || NEW.animid || '), Value (EntryDate) = (' || NEW.entrydate - || ': Key (WATCHES.WID) = (' + || '): Key (WATCHES.WID) = (' || a_wid || '), Value (WATCHES.Date) = (' || a_date @@ -527,7 +527,7 @@ CREATE OR REPLACE FUNCTION biography_data_func () || NEW.animid || '), Value (DepartDate) = (' || NEW.departdate - || ': Key (WATCHES.WID) = (' + || '): Key (WATCHES.WID) = (' || a_wid || '), Value (WATCHES.Date) = (' || a_date @@ -569,7 +569,7 @@ CREATE OR REPLACE FUNCTION biography_data_func () || NEW.animid || '), Value (Sex) = (' || NEW.sex - || ': Key (SWELLING_SOURCES.ID) = (' + || '): Key (SWELLING_SOURCES.ID) = (' || a_id || '), Value (SWELLING_SOURCES.Date) = (' || a_date @@ -601,7 +601,7 @@ CREATE OR REPLACE FUNCTION biography_data_func () || NEW.animid || '), Value (EntryDate) = (' || NEW.entrydate - || ': Key (SWELLING_SOURCES.ID) = (' + || '): Key (SWELLING_SOURCES.ID) = (' || a_id || '), Value (SWELLING_SOURCES.Date) = (' || a_date @@ -631,7 +631,7 @@ CREATE OR REPLACE FUNCTION biography_data_func () || NEW.animid || '), Value (DepartDate) = (' || NEW.departdate - || ': Key (SWELLING_SOURCES.ID) = (' + || '): Key (SWELLING_SOURCES.ID) = (' || a_id || '), Value (SWELLING_SOURCES.Date) = (' || a_date @@ -680,7 +680,7 @@ CREATE OR REPLACE FUNCTION biography_data_func () || NEW.animid || '), Value (Sex) = (' || NEW.sex - || ': Key (REPRO_STATES.ReID) = (' + || '): Key (REPRO_STATES.ReID) = (' || a_reid || '), Value (REPRO_STATES.Date) = (' || a_date @@ -722,7 +722,7 @@ CREATE OR REPLACE FUNCTION biography_data_func () || NEW.animid || '), Value (DepartDate) = (' || NEW.departdate - || ': Key (REPRO_STATES.ReID) = (' + || '): Key (REPRO_STATES.ReID) = (' || a_reid || '), Value (REPRO_STATES.Date) = (' || a_date @@ -1407,7 +1407,7 @@ CREATE OR REPLACE FUNCTION biography_data_func () || NEW.sex || '), Value (BirthDate) = (' || NEW.birthdate - || ': Key (ELO_RANKS_DAILY_KK_F.ID) = (' + || '): Key (ELO_RANKS_DAILY_KK_F.ID) = (' || a_id || '), Value (ELO_RANKS_DAILY_KK_F.Date) = (' || a_date diff --git a/db/schemas/lib/triggers/create/events.m4 b/db/schemas/lib/triggers/create/events.m4 index 83b2d85..c0ee944 100644 --- a/db/schemas/lib/triggers/create/events.m4 +++ b/db/schemas/lib/triggers/create/events.m4 @@ -226,7 +226,7 @@ CREATE OR REPLACE FUNCTION events_insert_commit_func () || a_animid || '), Value (WATCHES.Date) = (' || a_date - || ': Key (ARRIVALS.EID) = (' + || '): Key (ARRIVALS.EID) = (' || NEW.eid || '): Value (ARRIVALS.Seq) = (' || a_seq diff --git a/db/schemas/lib/triggers/create/watches.m4 b/db/schemas/lib/triggers/create/watches.m4 index 626b4de..dd9f415 100644 --- a/db/schemas/lib/triggers/create/watches.m4 +++ b/db/schemas/lib/triggers/create/watches.m4 @@ -199,7 +199,7 @@ CREATE OR REPLACE FUNCTION watches_func () || a_start || '), Value (EVENTS.Stop) = (' || a_stop - || ': Key (ROLES.PID) = (' + || '): Key (ROLES.PID) = (' || a_pid || '), Value (ROLES.Role) = (' || a_role @@ -251,7 +251,7 @@ CREATE OR REPLACE FUNCTION watches_func () || a_start || '), Value (EVENTS.Stop) = (' || a_stop - || ': Key (ROLES.PID) = (' + || '): Key (ROLES.PID) = (' || a_pid || '), Value (ROLES.Role) = (' || a_role @@ -321,7 +321,7 @@ CREATE OR REPLACE FUNCTION watches_func () || a_pid || '), Value (ROLES.Role) = (' || a_role - || ': Key (BIOGRAPHY_DATA.AnimID) = (' + || '): Key (BIOGRAPHY_DATA.AnimID) = (' || a_participant || '): Value (BIOGRAPHY_DATA.Sex) = (' || a_sex @@ -392,7 +392,7 @@ CREATE OR REPLACE FUNCTION watches_func () || a_pid || '), Value (ROLES.Role) = (' || a_role - || ': Key (BIOGRAPHY_DATA.AnimID) = (' + || '): Key (BIOGRAPHY_DATA.AnimID) = (' || a_participant || '): Value (BIOGRAPHY_DATA.Sex) = (' || a_sex @@ -468,7 +468,7 @@ CREATE OR REPLACE FUNCTION watches_func () || a_pid || '), Value (ROLES.Role) = (' || a_role - || ': Key (BIOGRAPHY_DATA.AnimID) = (' + || '): Key (BIOGRAPHY_DATA.AnimID) = (' || a_participant || '): Value (BIOGRAPHY_DATA.Sex) = (' || a_sex @@ -545,7 +545,7 @@ CREATE OR REPLACE FUNCTION watches_func () || a_pid || '), Value (ROLES.Role) = (' || a_role - || ': Key (BIOGRAPHY_DATA.AnimID) = (' + || '): Key (BIOGRAPHY_DATA.AnimID) = (' || a_participant || '): Value (BIOGRAPHY_DATA.Sex) = (' || a_sex @@ -673,7 +673,7 @@ CREATE OR REPLACE FUNCTION watches_insert_commit_func () || NEW.Date || '), Value (CommID) = (' || NEW.commid - || ': Key (EVENTS.EID) = (' + || '): Key (EVENTS.EID) = (' || a_eid || '), Value (EVENTS.WID) = (' || NEW.wid -- 2.34.1