Re: [BUGS] pg_dumpall failed on dumpProcLangs()

Roland Roberts <roberts(at)panix(dot)com> writes:
> -----BEGIN PGP SIGNED MESSAGE-----
> I was attempting to dump my database (6.4.2) in preparation for an
> upgrade to 6.5.1. I got the following error, both with and without
> the `-z'. Any suggestions are welcome....
> dumpProcLangs(): handler procedure for language plpgsql not found

That's odd. You didn't do something silly like dropping the function
definition for plpgsql_call_handler, did you?

Anyway, I think you can get rid of the broken table entry by doing
drop procedural language 'plpgsql';
but first you might want to see whether there are any functions
that depend on it:
select proname from pg_proc, pg_language pl
where prolang = pl.oid and lanname = 'plpgsql';
If there are, you'll need to drop them too...

regards, tom lane