| From: | Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> |
|---|---|
| To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Cc: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
| Subject: | Re: some last patches breaks plan cache |
| Date: | 2018-03-31 17:56:56 |
| Message-ID: | a9b9e308-bd14-3460-b61b-b06d4b7b1e17@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2018-03-31 18:03:38 | Re: [HACKERS][PATCH] adding simple sock check for windows |
| Previous Message | Pavel Stehule | 2018-03-31 17:38:42 | some last patches breaks plan cache |