Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: pg_dump failure: "handler procedure for language plpgsql not foun d"
Date
Msg-id 23892.988068161@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump failure: "handler procedure for language plpgsql not foun d"  (Jeff Eckermann <jeckermann@verio.net>)
List pgsql-general
Tree view 
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: "Dave Cramer"
Date:
Subject: Re: Auto increment?
Next
From: Peter Pilsl
Date:
Subject: find position of an special entry in a select-result