Re: BUG #18574: procedure cache does not invalidate when output parameter type mismatch - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #18574: procedure cache does not invalidate when output parameter type mismatch
Date
Msg-id 2051174.1723049747@sss.pgh.pa.us
Whole thread Raw
In response to BUG #18574: procedure cache does not invalidate when output parameter type mismatch  (PG Bug reporting form <noreply@postgresql.org>)
List 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 by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #18576: Using EXPLAIN (VERBOSE) in information_schema.element_types returns ERROR: failed to find plan for
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #18541: Reattaching a partition referenced by a foreign key fails with an error