"Jason Underdown" <[EMAIL PROTECTED]> writes:
> [EMAIL PROTECTED] jason]$ createlang plpgsql esi
> ERROR: function plpgsql_call_handler already exists with same argument
> types
> createlang: language installation failed
> [EMAIL PROTECTED] jason]$
> [EMAIL PROTECTED] 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
