Horton

Thread

  1. Re: [BUGS] pg_dumpall failed on dumpProcLangs()

    Tom Lane <tgl@sss.pgh.pa.us> — 1999-09-05T15:59:26Z

    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

  2. Re: [BUGS] pg_dumpall failed on dumpProcLangs()

    Roland Roberts <roberts@panix.com> — 1999-09-06T02:45:25Z

    -----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-----