Re: prepare in a do loop - Mailing list pgsql-general

From David G. Johnston
Subject Re: prepare in a do loop
Date
Msg-id CAKFQuwZa0jKc9ipDv-uKo2ZWwUvov6o_dvuw2ynTWpJDiax-rQ@mail.gmail.com
Whole thread Raw
In response to prepare in a do loop  (Marc Millas <marc.millas@mokadb.com>)
List pgsql-general
On Mon, Feb 15, 2021 at 9:19 AM Marc Millas <marc.millas@mokadb.com> wrote:

postgres=# prepare moninsert(varchar) as

do $$ begin for counter in 1..1000000 loop execute moninsert(randname());end loop;end;$$;
ERREUR:  la fonction moninsert(character varying) n'existe pas
someone can explain ?


From the pl/pgsql docs:

"The PL/pgSQL EXECUTE statement is not related to the EXECUTE SQL statement supported by the PostgreSQL server. The server's EXECUTE statement cannot be used directly within PL/pgSQL functions (and is not needed)."


David J.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: prepare in a do loop
Next
From: Ron
Date:
Subject: Re: ADD FOREIGN KEY fails, but the records exist