From 982b35848ba0af7e7462768a4807189d0e51fda8 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Thu, 9 Oct 2025 02:46:02 +0000 Subject: [PATCH] Fix reporting of ROLES.PID in error messages --- db/schemas/lib/triggers/create/arrivals.m4 | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/db/schemas/lib/triggers/create/arrivals.m4 b/db/schemas/lib/triggers/create/arrivals.m4 index 40698d9..668d1b5 100644 --- a/db/schemas/lib/triggers/create/arrivals.m4 +++ b/db/schemas/lib/triggers/create/arrivals.m4 @@ -119,6 +119,7 @@ CREATE OR REPLACE FUNCTION arrivals_func () a_focal follows.focal%TYPE; a_date follows.date%TYPE; -- ROLES + a_pid roles.pid%TYPE; a_role roles.role%TYPE; -- BIOGRAPHY_DATA a_animid biography_data.animid%TYPE; @@ -128,12 +129,12 @@ CREATE OR REPLACE FUNCTION arrivals_func () BEGIN -- Get the data we need, and that needed for error message content too SELECT events.eid, events.behavior, events.start, events.stop - , roles.role + , roles.role, roles.pid , biography_data.animid, biography_data.sex , biography_data.birthdate , follows.fid, follows.focal, follows.date INTO a_eid , a_behavior , a_start , a_stop - , a_role + , a_role , a_pid , a_animid , a_sex , a_birthdate , a_fid , a_focal , a_date -- 2.34.1