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