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:[EMAIL PROTECTED]]
> Sent: Thursday, May 31, 2001 12:26 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
