Unable to create or drop plpgsql

"Jason Underdown" <jasonu@xmission.com> writes:

[jason@user-44 jason]$ createlang plpgsql esi
ERROR: function plpgsql_call_handler already exists with same argument
types
createlang: language installation failed
[jason@user-44 jason]$
[jason@user-44 jason]$ droplang plpgsql esi
droplang: language "plpgsql" is not installed in database esi

You seem to have gotten stuck in a halfway-done state: the pg_language
table entry for plpgsql isn't there, but the pg_proc entry for its
supporting language handler is there. What you'll have to do is
manually drop the pg_proc entry. Try this SQL command as superuser:
drop function plpgsql_call_handler();
After that createlang should work.

If this is on a current release, I'd be interested to know how you got
into this state.

regards, tom lane

Tom,

Thank you for your instructions. They fixed my problem!

In answer to your questions, I am running:
temp=# select Version();
version
-------------------------------------------------------------
PostgreSQL 7.3.2 on i686-pc-linux-gnu, compiled by GCC 2.96

As for how I got into such a state, I don't know. But I suspect it happened
either when transferring the database via a text file to a new machine. (I
think I used pg_dump with the -d, and -O options) Or, maybe it happened when
I updated from 7.2 to 7.3 via RPMs (from the postgresql.org site). I
upgraded after moving the database.

Thanks,
Jason