Re: Unable to create or drop plpgsql

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

> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: Friday, June 20, 2003 8:44 PM
> To: Jason Underdown
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Unable to create or drop plpgsql
>
>
> "Jason Underdown" <jasonu(at)xmission(dot)com> writes:
> > [jason(at)user-44 jason]$ createlang plpgsql esi
> > ERROR: function plpgsql_call_handler already exists with same argument
> > types
> > createlang: language installation failed
> > [jason(at)user-44 jason]$
> > [jason(at)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
>