Date: Mon, 30 Aug 2021 14:09:48 +0200
From: hubert depesz lubaczewski <depesz@depesz.com>
Sender: depesz@depesz.com
To: Roger Mason <rmason@mun.ca>
Cc: pgsql-novice mailing list <pgsql-novice@postgresql.org>
Subject: Re: trigger fails
Message-ID: <20210830120948.GA19692@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>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <y65o89fnnoh.fsf@mun.ca>
User-Agent: Mutt/1.10.1 (2018-07-13)
Archived-At: 
 <https://www.postgresql.org/message-id/20210830120948.GA19692%40depesz.com>
Precedence: bulk

On Mon, Aug 30, 2021 at 09:34:46AM -0230, Roger Mason wrote:
> > Can you provide whole, testable sql script? With create table, and test
> > insert, that should generate something in the target table, that is
> > missing?

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.

Best regards,

depesz