Re: BUG #18574: procedure cache does not invalidate when output parameter type mismatch

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #18574: procedure cache does not invalidate when output parameter type mismatch
Дата
Msg-id 2051174.1723049747@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #18574: procedure cache does not invalidate when output parameter type mismatch  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> The reproduced script is as above. There is one out parameter in the two
> procedures. In the initial state, we make their types do not match and call
> the fisrt procedure which internally calls the other procedure. Then we will
> get "procedure parameter "r1" is an output parameter but corresponding
> argument is not writable". After this, we drop procedure + create procedure
> for p2. In this time, we re-call the fisrt procedure,we will get "cache
> lookup failed for function". 

Fixed, thanks for the report!

            regards, tom lane



В списке pgsql-bugs по дате отправления: