ERROR: plpgsql: cache lookup for proc 17911 failed

From: Richard Emberson <emberson(at)phc(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: ERROR: plpgsql: cache lookup for proc 17911 failed
Date: 2002-03-27 18:06:00
Message-ID: 3CA20A08.2BFAB689@phc.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-admin by date

  From Date Subject
Next Message Marc Mitchell 2002-03-27 22:26:15 pg_dump and views
Previous Message Stephan Szabo 2002-03-27 17:43:08 Re: timestamp in 7.2