"dumpProcLangs(): handler procedure for language plpgsql not found" on 7.0.3

From: Brian Fujito <brian(at)lightsource(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: "dumpProcLangs(): handler procedure for language plpgsql not found" on 7.0.3
Date: 2002-12-09 17:45:33
Message-ID: 1039455934.1378.58.camel@brian.lightsource.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2002-12-09 19:28:02 Re: "dumpProcLangs(): handler procedure for language plpgsql not found" on 7.0.3
Previous Message Tom Lane 2002-12-09 16:47:08 Re: WAL disk space