Re: repeated procedure call error
От | Pavel Stehule |
---|---|
Тема | Re: repeated procedure call error |
Дата | |
Msg-id | CAFj8pRBHQhz584Z-8qMJa4-2zmSMRDFJnoiD-tv474u1_15o7g@mail.gmail.com обсуждение исходный текст |
Ответ на | repeated procedure call error (Pavel Stehule <pavel.stehule@gmail.com>) |
Ответы |
Re: repeated procedure call error
|
Список | pgsql-hackers |
pá 9. 11. 2018 v 20:05 odesílatel Pavel Stehule <pavel.stehule@gmail.com> napsal:
HiThere 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 CALLfirst error message is correct,Second call fails with unexpected errorERROR: 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?
regardsPavel
В списке pgsql-hackers по дате отправления: