Re: [GENERAL] plpgsql - cache lookup error 18977

2000-10-18 Thread Tom Lane
Tom Walta <[EMAIL PROTECTED]> 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

[GENERAL] plpgsql - cache lookup error 18977

2000-10-18 Thread Tom Walta
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 e