"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