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
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.
Show quoted text
-----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
Import Notes
Resolved by subject fallback