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
