On Mon, Feb 15, 2021 at 9:19 AM Marc Millas <marc.mil...@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)." https://www.postgresql.org/docs/current/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN David J.
