Re: trigger fails

From: Roger Mason <rmason(at)mun(dot)ca>
To: depesz(at)depesz(dot)com
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: trigger fails
Date: 2021-08-30 13:33:33
Message-ID: y65lf4jnjki.fsf@mun.ca
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message hubert depesz lubaczewski 2021-08-30 13:36:17 Re: trigger fails
Previous Message hubert depesz lubaczewski 2021-08-30 12:09:48 Re: trigger fails