I was bitten by the same problem recently. It means that the owner of the
pgsql call handler no longer exists. To find out the id of the owner, do a
select like:
select * from pg_proc where proname like 'plpg%';
Then create a user having that id. You may need to edit pg_shadow to get
the desired result.
> -----Original Message-----
> From: Luis Magaña [SMTP:joe666@gnovus.com]
> Sent: Thursday, May 31, 2001 12:26 PM
> To: pgsql-hackers@postgresql.org; pgsql-general@postgresql.org
> Subject: [GENERAL] pg_dump & pg_dumpall problem.
>
> Hi there:
>
> Would like to know how to fix this:
>
> Everytime I do a pg_dump or pg_dumpall I get this error message:
>
> dumpProcLangs(): handler procedure for language plpgsql not found
>
> Any help would be appreciated.
>
> Thank you in advanced.
> --
> Ing. Luis Magaña
> Gnovus Networks & Software
> www.gnovus.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster