Re: trigger fails

On Saturday, August 28, 2021, Roger Mason <rmason(at)mun(dot)ca> wrote:

>
> I have tried various modifications of get_final_energy without success.
>

If get_final_energy() isn’t working as you expect (and its definition is
highly suspect so I wouldn’t be surprised) then all of this talk about
triggers is just adding unnecessary distraction. Don’t add triggers to the
mix until you know the components are all functioning correctly.

I’d also suggest not doing create table if not exists in a trigger.
Whatever code you use to install the triggers should create the table
immediately and then the trigger just assumes it is present.

As for debugging the big query, you just need to learn by doing. Start
writing it again from scratch and when you get to a point where it provide
unusual results stop and figure out why.

David J.