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:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 6:23 PM
To: Jeff Eckermann
Cc: '[EMAIL PROTECTED]'
Subject: Re: [GENERAL] pg_dump failure: handler procedure for
language plpgsql not foun d
Jeff Eckermann [EMAIL PROTECTED] 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
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
