Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Removing languages

From: Ian Phillips <ian(at)comodo(dot)net>
To: ian(at)comodo(dot)net, pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Removing languages
Date: 1999-10-28 15:31:26
Message-ID: 99102815323902.00677@Gromit (view raw or flat)
Thread:
Lists: pgsql-general
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(at)comodo(dot)net    ipp(at)sygmabox(dot)freeserve(dot)co(dot)uk
> 07971 329 279     www.sygmabox.freeserve.co.uk
> 
> ************
--
--------------
Ian Phillips
ian(at)comodo(dot)net    ipp(at)sygmabox(dot)freeserve(dot)co(dot)uk
07971 329 279     www.sygmabox.freeserve.co.uk

In response to

pgsql-general by date

Next:From: S. van der TolDate: 1999-10-28 18:01:13
Subject: Problem with initdb
Previous:From: Ross J. ReedstromDate: 1999-10-28 15:10:37
Subject: Re: [GENERAL] pgsql pg_connect

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group