RE: pg_dump failure: "handler procedure for language pl pgsql not foun d" - Mailing list pgsql-general

From Jeff Eckermann
Subject RE: pg_dump failure: "handler procedure for language pl pgsql not foun d"
Date
Msg-id 08CD1781F85AD4118E0800A0C9B8580B094A44@NEZU
Whole thread Raw
List 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@sss.pgh.pa.us]
> Sent:    Monday, April 23, 2001 6:23 PM
> To:    Jeff Eckermann
> Cc:    'pgsql-general@postgresql.org'
> Subject:    Re: [GENERAL] pg_dump failure: "handler procedure for
> language plpgsql not foun d"
>
> Jeff Eckermann <jeckermann@verio.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

pgsql-general by date:

Previous
From: Peter Keller
Date:
Subject: indices are crashed after installation of rpm
Next
From: Bruce Momjian
Date:
Subject: IBM to buy Informix