[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Removing languages
From:       Ian Phillips <ian () comodo ! net>
Date:       1999-10-28 14:44:09
[Download RAW message or body]

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

************

[prev in list] [next in list] [prev in thread] [next in thread]