From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
---|---|
To: | Roger Mason <rmason(at)mun(dot)ca> |
Cc: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: trigger fails |
Date: | 2021-08-30 13:36:17 |
Message-ID: | 20210830133617.GA9900@depesz.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Pól Ua Laoínecháin | 2021-09-01 16:19:25 | Using PGTune - is it a good source for system configuration? |
Previous Message | Roger Mason | 2021-08-30 13:33:33 | Re: trigger fails |