Re: trigger fails

Поиск
Список
Период
Сортировка
От Roger Mason
Тема Re: trigger fails
Дата
Msg-id y65lf4jnjki.fsf@mun.ca
обсуждение исходный текст
Ответ на Re: trigger fails  (hubert depesz lubaczewski <depesz@depesz.com>)
Список 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 по дате отправления:

Предыдущее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: trigger fails
Следующее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: trigger fails