Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mKirL-0004qI-0X for pgsql-novice@arkaria.postgresql.org; Mon, 30 Aug 2021 15:06:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mKirK-000644-1B for pgsql-novice@arkaria.postgresql.org; Mon, 30 Aug 2021 15:06:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mKhQ2-00020u-6w for pgsql-novice@lists.postgresql.org; Mon, 30 Aug 2021 13:33:46 +0000 Received: from esa08.ucs.mun.ca ([134.153.136.28]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mKhPw-0006Ny-RL for pgsql-novice@postgresql.org; Mon, 30 Aug 2021 13:33:43 +0000 IronPort-SDR: VT1YLlzm3tFnIiEIfundTJUSfhpT7ZPZ6MQqh4VQ+9KAxWvpt8mPuzjRtFegz93uv0tGBeOHUf XOvKpF1QRHYmemzynfidQvdgjmz5mizyusp/BMP0LvIQaxlsoB3Xn4X2+f8CcCuybSpwCk2tGg PHURl3btu/dJ5kVLpWBxVeTCku1IRDMXrh9QgIJJVM+J1p79sMZ2bwvgcgc4FGZRnKiHqM+HPF o1/xQKswzdHGy71a1qfDNdtCm+yRZ9VxpPkyhXChdTNbGVcc3pSDtyO7ebQ3DBJpNHkIYiee4c cog= IronPort-HdrOrdr: =?us-ascii?q?A9a23=3AaNmLPqGiLuT/0rJppLqFpZLXdLJyesId70?= =?us-ascii?q?hD6qkvc3Bom52j+vxGws5w6fatskdoZJhSo6H6BEDgewKRyXcR2+Ys1NiZLW?= =?us-ascii?q?/bUPXBFvAE0WKP+V3d8k7Fh6FgPMVbAtFD4bTLZDAQ46fHCWGDYo8dKbK8gc?= =?us-ascii?q?KVbJLlvhNQpHZRGsRdBmlCe2WmO3wzYDMDKYsyFZKa6MYCjSGnY24rYsOyAW?= =?us-ascii?q?RAd/TfpvXQ/aiWLyIuNloC0k2jnDmo4Ln1H1yzxREFSQ5Cxr8k7CzsjxH53K?= =?us-ascii?q?O+qPu2oyWsllM7rq4m2OcJ+OEzRvBkufJlbwkETTzYILiJbofy/wzdZtvfr2?= =?us-ascii?q?rC3uO85SvIdP4DkU85NlvF3CcFnTOQiArGokWStmOwkD/tp9f0Syk9DNcEjY?= =?us-ascii?q?VFcgHB405lp91k1rlXtljp/Ka/oimw7xgVyuK4Hi2CrHDE6UbKUNRj+kB3QM?= =?us-ascii?q?8bcvtcvIYf9ERaHNMJGz/78pkuFK1rANvH7PhbfFuGZzSB11MfjeCETzA2BF?= =?us-ascii?q?OLU0ICssua33xfm2141VIRwIgakm0b/JwwRpFY76DPM7hulrtJUsgKBJgNTt?= =?us-ascii?q?spUI+yECjAUBjMOGWdLRDuE7wGIWvEr9rt7LA89IiRCeo15Yp3nI6EXEJTtG?= =?us-ascii?q?Y0dU6rA8WK0JpH+guIWmmnXTj2jsFY/YVwvbfxALrnWBfzNmzGU/HQ1Mn3J/?= =?us-ascii?q?erKcpbFKgmcsMLHFGebbqhhTeOJ6W6AUNuIPEohg=3D=3D?= X-IronPort-AV: E=Sophos;i="5.84,363,1620700200"; d="scan'208";a="57302693" X-Amp-Result: SKIPPED(no attachment in message) X-Amp-File-Uploaded: False Received: from cpe00fc8db7a323-cm00fc8db7a320.cpe.net.cable.rogers.com (HELO pyrope.local) ([174.117.202.255]) by smtp08.ucs.mun.ca with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 30 Aug 2021 11:03:36 -0330 References: <20210830081718.GA8307@depesz.com> <20210830120948.GA19692@depesz.com> User-agent: mu4e 1.5.6; emacs 27.2 From: Roger Mason To: depesz@depesz.com Subject: Re: trigger fails cc: pgsql-novice In-reply-to: <20210830120948.GA19692@depesz.com> Date: Mon, 30 Aug 2021 11:03:33 -0230 Message-ID: MIME-Version: 1.0 Content-Type: text/plain List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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); Again please don't waste too much time on this. Best wishes, Roger