plpgsql - cache lookup error 18977

Started by Tom Waltaover 25 years ago2 messagesgeneral
Jump to latest
#1Tom Walta
twalta@yahoo.com

I entered the following to load plpgsql:
"$createlang -L/usr/lib/pgsql plpgsql testdb"
postgresql appeared to have no problem with it. A
subsequent "$createlang -l -dtestdb" showed plpgsql as
being a trusted procedural language. But whenever I
attempt to use it in a function I get the following
error:
"ERROR: fmgr_info: Cache lookup for language failed
18977"
What does this mean, or where can I find out what this
means?

Thanks.

__________________________________________________
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf! It's FREE.
http://im.yahoo.com/

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Tom Walta (#1)
Re: plpgsql - cache lookup error 18977

Tom Walta <twalta@yahoo.com> writes:

"ERROR: fmgr_info: Cache lookup for language failed 18977"

Did you perchance drop and recreate the plpgsql language when
you already had functions defined in the language? The system
will let you do that :-(, but then the old functions refer to
a language OID that no longer exists. You'll need to drop and
recreate the functions, too.

regards, tom lane