hi there, I'm running postgres-7.0.3 on RH7.1 using RedHat RPMs. I recently added plpgsql as a language to one of my databases, and now when I try to do a pg_dump, I get:
"dumpProcLangs(): handler procedure for language plpgsql not found" If I drop the language, pg_dump works fine, but if I add it back (and even if I restart postgres), I get the same error. That's on our production box. Strangely enough, If I do the same thing on my dev box (also RH 7.1 w/ 7.0.3), I don't get the error and the dump works fine, picking up my triggers and all. I've gone through and compared all rpm-installed files on the two boxes and they're identical... Any ideas on how to fix that error? thanks, brian -- Brian T. Fujito www.lightsource.com ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
