Re: prepare in a do loop

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Mon, Feb 15, 2021 at 9:19 AM Marc Millas <marc.millas@xxxxxxxxxx> 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)."

https://www.postgresql.org/docs/current/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN

David J.