ERROR: plpgsql: cache lookup for proc 17911 failed - Mailing list pgsql-admin

From Richard Emberson
Subject ERROR: plpgsql: cache lookup for proc 17911 failed
Date
Msg-id 3CA20A08.2BFAB689@phc.net
Whole thread Raw
List pgsql-admin
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


pgsql-admin by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: timestamp in 7.2
Next
From: "Marc Mitchell"
Date:
Subject: pg_dump and views