"dumpProcLangs(): handler procedure for language plpgsql not found" on 7.0.3 - Mailing list pgsql-admin

From Brian Fujito
Subject "dumpProcLangs(): handler procedure for language plpgsql not found" on 7.0.3
Date
Msg-id 1039455934.1378.58.camel@brian.lightsource.com
Whole thread Raw
Responses Re: "dumpProcLangs(): handler procedure for language plpgsql not found" on 7.0.3
List pgsql-admin
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




pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: WAL disk space
Next
From: Tom Lane
Date:
Subject: Re: "dumpProcLangs(): handler procedure for language plpgsql not found" on 7.0.3