Re: repeated procedure call error

pá 9. 11. 2018 v 20:05 odesílatel Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
napsal:

> Hi
>
> There are some broken. I tried to fix plpgsql_check regression tests and I
> found new error.
>
> Looks it is fresh regression.
>
> CREATE OR REPLACE PROCEDURE public.proc(a integer, INOUT b integer, c
> integer)
> LANGUAGE plpgsql
> AS $procedure$
> begin
> b := a + c + c;
> end;
> $procedure$
>
> CREATE OR REPLACE PROCEDURE public.testproc()
> LANGUAGE plpgsql
> AS $procedure$
> declare r int;
> begin
> call proc(10, r + 10, 20);
> end;
> $procedure$
>
> postgres=# call testproc();
> ERROR: procedure parameter "b" is an output parameter but corresponding
> argument is not writable
> CONTEXT: PL/pgSQL function testproc() line 4 at CALL
>
> first error message is correct,
>
> Second call fails with unexpected error
>
> ERROR: SPI_execute_plan_with_paramlist failed executing query "CALL
> proc(10, r + 10, 20)": SPI_ERROR_ARGUMENT
> CONTEXT: PL/pgSQL function testproc() line 4 at CALL
>

Maybe plan cache is broken due exception?

> regards
>
> Pavel
>
>
>