Re: [BUGS] pg_dumpall failed on dumpProcLangs()

From: Roland Roberts <roberts(at)panix(dot)com>
To: pgsql-bugs(at)postgreSQL(dot)org
Subject: Re: [BUGS] pg_dumpall failed on dumpProcLangs()
Date: 1999-09-06 02:45:25
Message-ID: m2lnakpxkq.fsf@tycho.rlent.pnet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

-----BEGIN PGP SIGNED MESSAGE-----

>>>>> "Tom" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

Tom> Roland Roberts <roberts(at)panix(dot)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(at)panix(dot)com 76-15 113th Street, Apt 3B
rbroberts(at)acm(dot)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-----

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Enrico Scholz 1999-09-06 12:17:40 SERIAL's in INSERT rules
Previous Message Tom Lane 1999-09-05 15:59:26 Re: [BUGS] pg_dumpall failed on dumpProcLangs()