Re: Executing a Function with an INSERT INTO command fails

From: TalGloz <glozmantal(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Executing a Function with an INSERT INTO command fails
Date: 2018-08-29 17:09:20
Message-ID: 1535562560912-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> I was referring specifically to:
>
> https://www.postgresql.org/docs/10/static/plpgsql-errors-and-messages.html#PLPGSQL-STATEMENTS-RAISE
>
> I was going for a conceptual communication, not syntax.
>
> Though if you indeed get a syntax error then that precludes the "wrong
> object" theory.

I hoe I got it right from the post, If I set RAISE EXCEPTION just right
after the beginning then I get

ERROR: syntax error at or near "INSERT"
LINE 31: INSERT INTO public.runtime_benchmark (test_number, column_n...

Tal

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

In response to

Browse pgsql-general by date

  From Date Subject
Next Message TalGloz 2018-08-29 17:24:11 Re: Executing a Function with an INSERT INTO command fails
Previous Message David G. Johnston 2018-08-29 16:54:02 Re: Executing a Function with an INSERT INTO command fails