On 03/31/2018 07:38 PM, Pavel Stehule wrote:
> Hi
>
> CREATE OR REPLACE PROCEDURE public.proc(a integer, INOUT b integer, c
> integer)
> LANGUAGE plpgsql
> AS $procedure$
> begin
> b := a + c;
> end;
> $procedure$
>
> CREATE OR REPLACE PROCEDURE public.testproc()
> LANGUAGE plpgsql
> AS $procedure$
> declare r int;
> begin
> call proc(10, r, 20);
> end;
> $procedure$
>
> postgres=# call testproc();
> CALL
> postgres=# call testproc();
> ERROR: SPI_execute_plan_with_paramlist failed executing query "CALL
> proc(10, r, 20)": SPI_ERROR_ARGUMENT
> CONTEXT: PL/pgSQL function testproc() line 4 at CALL
> postgres=#
>
> second call fails
Yeah.
d92bc83c48bdea9888e64cf1e2edbac9693099c9 seems to have broken this :-/
regards
--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services