Thread: plpgsql - cache lookup error 18977

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/

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