Thread: ERROR: plpgsql: cache lookup for proc 17911 failed

ERROR: plpgsql: cache lookup for proc 17911 failed

From
Richard Emberson
Date:
I created a function with iscachable,

' LANGUAGE 'plpgsql' WITH (iscachable);

I then call the function.
Then I decide to change the return type of the function so I first drop
the
function, then change the return type.
The next time I attempt to execute the function I get:

ERROR:  plpgsql: cache lookup for proc 17911 failed

I would have thought that dropping a function would have also cleared it
from the cache.

Richard