Postgres Pro
Downloads
Home   >   mailing lists

some last patches breaks plan cache - Mailing list pgsql-hackers

From Pavel Stehule
Subject some last patches breaks plan cache
Date
Msg-id CAFj8pRCUih28=Kb0u7WtBqSxkoR4=HYAxAYFYFuN-y2+SzZzdw@mail.gmail.com
Whole thread Raw
Responses Re: some last patches breaks plan cache  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-hackers
Tree view
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

Regards

Pavel

pgsql-hackers by date:

Previous
From: CharSyam
Date:
Subject: Re: [HACKERS][PATCH] adding simple sock check for windows
Next
From: Tomas Vondra
Date:
Subject: Re: some last patches breaks plan cache