From: | Jeff Eckermann <jeckermann(at)verio(dot)net> |
---|---|
To: | 'Luis Magaña' <joe666(at)gnovus(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | RE: pg_dump & pg_dumpall problem. |
Date: | 2001-05-31 22:58:01 |
Message-ID: | 08CD1781F85AD4118E0800A0C9B8580B094ACC@NEZU |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)gnovus(dot)com]
> Sent: Thursday, May 31, 2001 12:26 PM
> To: pgsql-hackers(at)postgresql(dot)org; pgsql-general(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Wolfe | 2001-05-31 23:04:05 | Re: Compiling to RPM setup/filesystem layout |
Previous Message | Trond Eivind =?iso-8859-1?q?Glomsr=F8d?= | 2001-05-31 22:42:14 | Re: Compiling to RPM setup/filesystem layout |