Re: trigger fails - Mailing list pgsql-novice

From Roger Mason
Subject Re: trigger fails
Date
Msg-id y65lf4jnjki.fsf@mun.ca
Whole thread Raw
In response to Re: trigger fails  (hubert depesz lubaczewski <depesz@depesz.com>)
List 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



pgsql-novice by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: trigger fails
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: trigger fails