Definite case of RTFM on my part...
DROP PROCEDURAL LANGUAGE 'plpgsql';
oops <blush>
On Thu, 28 Oct 1999, Ian Phillips wrote:
> Hi,
>
> I'm new to postgreSQL, so I hope someone can help me out with this little
> mistake.
>
> 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
> error).
>
> 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@comodo.net ipp@sygmabox.freeserve.co.uk
> 07971 329 279 www.sygmabox.freeserve.co.uk
>
> ************
--
--------------
Ian Phillips
ian@comodo.net ipp@sygmabox.freeserve.co.uk
07971 329 279 www.sygmabox.freeserve.co.uk