Hello,
David G. Johnston writes:
> On Sat, Aug 28, 2021 at 7:04 AM Roger Mason <rmason(at)mun(dot)ca> wrote:
>
>>
>> get_final_energy (NEW.jid);
>>
>>
> If you want to use this function within a trigger it should be redefined to
> accept "NEW" (i.e., the table record itself), not the jid column (IOW,
> don't perform a select on the table during the middle of the trigger
> execution).
I have not been able to get this to work: the trigger runs and the
trigger function is called but no new data are inserted into the target
table. Having spent several days on this without result it is time to
give up.
Thanks again for your help.
Roger