Re: some last patches breaks plan cache
| От | Tomas Vondra |
|---|---|
| Тема | Re: some last patches breaks plan cache |
| Дата | |
| Msg-id | a9b9e308-bd14-3460-b61b-b06d4b7b1e17@2ndquadrant.com обсуждение исходный текст |
| Ответ на | some last patches breaks plan cache (Pavel Stehule <pavel.stehule@gmail.com>) |
| Ответы |
Re: some last patches breaks plan cache
|
| Список | 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
В списке pgsql-hackers по дате отправления: