Re: Executing a Function with an INSERT INTO command fails

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Executing a Function with an INSERT INTO command fails
Дата
Msg-id CAKFQuwZDwSLgwzn7zooJRvK3rL-oZycB+rdiksT-dgpsZ5rOKA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Executing a Function with an INSERT INTO command fails  (TalGloz <glozmantal@gmail.com>)
Ответы Re: Executing a Function with an INSERT INTO command fails  (TalGloz <glozmantal@gmail.com>)
Список pgsql-general
On Wed, Aug 29, 2018 at 9:47 AM, TalGloz <glozmantal@gmail.com> wrote:

> Add "RAISE ERROR" to the top function's BEGIN block and verify that the
> next time you run your calling query it indeed fails.  I'm suspecting that
> the code you are iterating over is not the same code that is being
> executed
> (search_path dynamics probably).

Do you mean like this
BEGIN
RAISE NOTICE
.
.
INSERT INTO public.runtime_benchmark (test_number, column_names,
execution_time, operation_type, seal_or_sql) VALUES (1, 'Pickup_longitude,
Dropoff_longitude', '1', 'sub', 'seal');
.
.
END;

If I use RAISE ERROR i get ERROR:  unrecognized exception condition "error"


I was referring specifically to:


I was going for a conceptual communication, not syntax.

Though if you indeed get a syntax error then that precludes the "wrong object" theory.

David J.

В списке pgsql-general по дате отправления:

Предыдущее
От: TalGloz
Дата:
Сообщение: Re: Executing a Function with an INSERT INTO command fails
Следующее
От: TalGloz
Дата:
Сообщение: Re: Executing a Function with an INSERT INTO command fails