Re: trigger fails

On Mon, Aug 30, 2021 at 11:03:33AM -0230, Roger Mason wrote:
> Hello again,
>
> hubert depesz lubaczewski writes:
>
> > it's better to reply to mailing list, unless it's a secret, as others
> > can comment and possibly provide answer.
> >
> > In any case, after running your queries, I got:
> >
> > ERROR: relation "results" does not exist
> >
> > This was on test script line 78, which was:
> >
> > CREATE TRIGGER trigger_f_energy_insert AFTER INSERT ON results FOR EACH ROW
> > EXECUTE PROCEDURE trigger_f_energy_insert ();
> >
> > So, can't test it, sorry.
>
> This should be sufficient:
>
> create table results (timestamp text,jid text,machine text,info_out
> text);

Now your script fails with:
ERROR: column results.totenergy_out does not exist

If you want help, please, pretty please with cherry on top - make
*usable* test script.
Write it, test by psql -f ..., and then send if it:
1. works
2. shows the problem

Best regards,

depesz