From: | Jeff Eckermann <jeckermann(at)verio(dot)net> |
---|---|
To: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
Subject: | RE: pg_dump failure: "handler procedure for language pl pgsql not foun d" |
Date: | 2001-04-24 14:33:21 |
Message-ID: | 08CD1781F85AD4118E0800A0C9B8580B094A44@NEZU |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Tom,
Absolutely right! I suppose I could have figured that out if I had spent
three days looking at it :-)
I didn't find anything in the docs about assigning a sysid to a new user, so
I just did a createuser and an UPDATE to pg_shadow to reset the sysid.
If that is likely to cause a problem, please let me know. In any case,
pg_dump is now working for me.
Thank you once again for your valuable help.
Regards
> -----Original Message-----
> From: Tom Lane [SMTP:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: Monday, April 23, 2001 6:23 PM
> To: Jeff Eckermann
> Cc: 'pgsql-general(at)postgresql(dot)org'
> Subject: Re: [GENERAL] pg_dump failure: "handler procedure for
> language plpgsql not foun d"
>
> Jeff Eckermann <jeckermann(at)verio(dot)net> writes:
> > I am attempting to do a pg_dump, preparing to upgrade to 7.1.
> > I have attempted a pg_dumpall, as well as pg_dump for various individual
> > databases, and each fails with the message "dumpProcLangs(): handler
> > procedure for language plpgsql not found"
>
> Hmm, does plpgsql_call_handler's proowner appear in pg_shadow? If not,
> add a user with the correct sysid...
>
> regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Fran Fabrizio | 2001-04-24 14:48:25 | Re: installing DBD::Pg without installing postgres |
Previous Message | Peter Keller | 2001-04-24 14:08:41 | indices are crashed after installation of rpm |