Date: Mon, 30 Aug 2021 15:36:17 +0200
From: hubert depesz lubaczewski <depesz@depesz.com>
Sender: depesz@depesz.com
To: Roger Mason <rmason@mun.ca>
Cc: pgsql-novice <pgsql-novice@postgresql.org>
Subject: Re: trigger fails
Message-ID: <20210830133617.GA9900@depesz.com>
Reply-To: depesz@depesz.com
References: <y65sfyteme4.fsf@mun.ca>
 <CAKFQuwbT_8bzKcJohUVmR_N--x5h9X-dB2rhozz6b99ynd6rpw@mail.gmail.com>
 <y65czpwo2p2.fsf@mun.ca>
 <20210830081718.GA8307@depesz.com>
 <y65o89fnnoh.fsf@mun.ca>
 <20210830120948.GA19692@depesz.com>
 <y65lf4jnjki.fsf@mun.ca>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <y65lf4jnjki.fsf@mun.ca>
User-Agent: Mutt/1.10.1 (2018-07-13)
Archived-At: 
 <https://www.postgresql.org/message-id/20210830133617.GA9900%40depesz.com>
Precedence: bulk

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