pg_dumpall failed on dumpProcLangs()
-----BEGIN PGP SIGNED MESSAGE-----
I was attempting to dump my database (6.4.2) in preparation for an
upgrade to 6.5.1. I got the following error, both with and without
the `-z'. Any suggestions are welcome....
999 roland> pg_dumpall -v -z > ~/stuff/pgdump.dat
- -- last builtin oid is 17152
- -- reading user-defined types
- -- reading user-defined functions
- -- reading user-defined aggregates
- -- reading user-defined operators
- -- reading user-defined tables
- -- reading table inheritance information
- -- finding the attribute names and types for each table
- -- finding the attrs and types for table: 'addresses'
- -- finding the attrs and types for table: 'contacts'
- -- finding the attrs and types for table: 'dictionary'
- -- finding DEFAULT expression for attr: '_rowid'
- -- finding the attrs and types for table: 'ebulk'
- -- finding DEFAULT expression for attr: '_rowid'
- -- finding DEFAULT expression for attr: 'browref'
- -- finding the attrs and types for table: 'eschema'
- -- finding DEFAULT expression for attr: '_rowid'
- -- finding the attrs and types for table: 'filters'
- -- finding DEFAULT expression for attr: '_rowid'
- -- finding the attrs and types for table: 'followups'
- -- finding DEFAULT expression for attr: '_rowid'
- -- finding DEFAULT expression for attr: 'f_sid'
- -- finding the attrs and types for table: 'groups'
- -- finding the attrs and types for table: 'master'
- -- finding the attrs and types for table: 'members'
- -- finding the attrs and types for table: 'people'
- -- finding DEFAULT expression for attr: '_rowid'
- -- finding the attrs and types for table: 'phones'
- -- finding the attrs and types for table: 'policy'
- -- finding DEFAULT expression for attr: 'pid'
- -- finding the attrs and types for table: 'policy_grp'
- -- finding DEFAULT expression for attr: '_rowid'
- -- finding DEFAULT expression for attr: 'pid'
- -- finding the attrs and types for table: 'policy_login'
- -- finding DEFAULT expression for attr: '_rowid'
- -- finding DEFAULT expression for attr: 'pid'
- -- finding the attrs and types for table: 'preferences'
- -- finding DEFAULT expression for attr: '_rowid'
- -- finding the attrs and types for table: 'propdisp'
- -- finding DEFAULT expression for attr: '_rowid'
- -- finding the attrs and types for table: 'resources'
- -- finding the attrs and types for table: 'slips'
- -- finding DEFAULT expression for attr: 'sid'
- -- finding DEFAULT expression for attr: 'spid'
- -- finding the attrs and types for table: 'state'
- -- finding DEFAULT expression for attr: '_rowid'
- -- finding the attrs and types for table: 'statelist'
- -- finding the attrs and types for table: 'status'
- -- flagging inherited attributes in subtables
- -- dumping out user-defined types
- -- dumping out tables
- -- dumping out user-defined procedural languages
dumpProcLangs(): handler procedure for language plpgsql not found
pg_dump failed on ksonline, exiting
roland
- --
PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD Custom Software Solutions
roberts@panix.com 76-15 113th Street, Apt 3B
rbroberts@acm.org Forest Hills, NY 11375
-----BEGIN PGP SIGNATURE-----
Version: 2.6.3a
Charset: noconv
Comment: Processed by Mailcrypt 3.5.4, an Emacs/PGP interface
iQCVAwUBN9Hr9uoW38lmvDvNAQFO/AQAjX+1cN7UaVLHtCn1RwEdl6TvQuHdVWtF
/g2kd9ey/qts4GQ5ZQBjnuFZp+ZU8PxpyUiTkS63gbKqGhruXKVWps1N/E+ctinC
ObAwMags+LgdGYVktDl18TjBzSB7hov7SKBDBvAITTOy8idto7ZldvnI7aP907x5
sZAKtzVuau8=
=9/Wn
-----END PGP SIGNATURE-----
Roland Roberts <roberts@panix.com> writes:
-----BEGIN PGP SIGNED MESSAGE-----
I was attempting to dump my database (6.4.2) in preparation for an
upgrade to 6.5.1. I got the following error, both with and without
the `-z'. Any suggestions are welcome....
dumpProcLangs(): handler procedure for language plpgsql not found
That's odd. You didn't do something silly like dropping the function
definition for plpgsql_call_handler, did you?
Anyway, I think you can get rid of the broken table entry by doing
drop procedural language 'plpgsql';
but first you might want to see whether there are any functions
that depend on it:
select proname from pg_proc, pg_language pl
where prolang = pl.oid and lanname = 'plpgsql';
If there are, you'll need to drop them too...
regards, tom lane
Import Notes
Reply to msg id not found: Yourmessageof05Sep1999000517-0400m2so4uoveq.fsf@tycho.rlent.pnet | Resolved by subject fallback
-----BEGIN PGP SIGNED MESSAGE-----
"Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:
Tom> Roland Roberts <roberts@panix.com> writes:
dumpProcLangs(): handler procedure for language plpgsql not
found
Tom> That's odd. You didn't do something silly like dropping the
Tom> function definition for plpgsql_call_handler, did you?
I don't think so. When I originally installed 6.4.2, I did it from
the source RPM. I then loaded the plpgsql language support manually
from the suppplied script.
Tom> Anyway, I think you can get rid of the broken table entry by
Tom> doing drop procedural language 'plpgsql'; but first you might
Tom> want to see whether there are any functions that depend on
[...]
This show not procedures; I remember defining some, but perhaps I
dropped them after experimenting.
Thanks!
roland
- --
PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD Custom Software Solutions
roberts@panix.com 76-15 113th Street, Apt 3B
rbroberts@acm.org Forest Hills, NY 11375
-----BEGIN PGP SIGNATURE-----
Version: 2.6.3a
Charset: noconv
Comment: Processed by Mailcrypt 3.5.4, an Emacs/PGP interface
iQCVAwUBN9MqwuoW38lmvDvNAQHonAQAue0yOg50NlS9vErxY8vkyvlfcLRE+ROH
8LtOu7wZzszINXsmniyJvi/rip0hG+sktZVLrGM7+gf5HjkkXd77M6SqjbHey6nN
J4NDSlQsnXDQdFiluRQa8cJFEioQb7wyeIrnaOFm6CGalpb/hHns7e+GzUo4s/lJ
EcV9N31tecc=
=ICZX
-----END PGP SIGNATURE-----
Import Notes
Reply to msg id not found: TomLane'smessageofSun05Sep1999115926-0400