Re: pg_dump failure: "handler procedure for language plpgsql not foun d"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Eckermann <jeckermann(at)verio(dot)net>
Cc: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_dump failure: "handler procedure for language plpgsql not foun d"
Date: 2001-04-23 23:22:41
Message-ID: 23892.988068161@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jason Davis 2001-04-23 23:30:45 Re: Re: CAST doesn't work
Previous Message Dave Cramer 2001-04-23 23:08:45 Re: Auto increment?