Definite case of RTFM on my part...
DROP PROCEDURAL LANGUAGE 'plpgsql';
On Thu, 28 Oct 1999, Ian Phillips wrote:
> I'm new to postgreSQL, so I hope someone can help me out with this little
> When adding the plpgsql language to the template1 db, I mistyped the path for
> the plpgsql.so file. I didn't spot this until I came to use a plpgsql
> function. Consequently, I DROPped the function and CREATEd a new one.
> Unfortunately, the entry in the pg_languages table now has the wrong OID in it.
> Is it safe to do a
> DELETE FROM pg_languages WHERE lanname = 'plpgsql';
> and then redo the CREATE TRUSTED PROCEDURAL LANGUAGE?
> BTW, I've tried DROP TRUSTED PROCEDURAL LANGUAGE and it didn't work (parser
> Any help is appreciated. In the meantime, I'm having to recreate the language
> by hand for each database...
> Thanx in advance.
> Ian Phillips
> ian(at)comodo(dot)net ipp(at)sygmabox(dot)freeserve(dot)co(dot)uk
> 07971 329 279 www.sygmabox.freeserve.co.uk
07971 329 279 www.sygmabox.freeserve.co.uk
In response to
pgsql-general by date
|Next:||From: S. van der Tol||Date: 1999-10-28 18:01:13|
|Subject: Problem with initdb|
|Previous:||From: Ross J. Reedstrom||Date: 1999-10-28 15:10:37|
|Subject: Re: [GENERAL] pgsql pg_connect|