Removing languages

Поиск
Список
Период
Сортировка
Искать

Removing languages

От:
Ian Phillips <ian@comodo.net>
Дата:
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

Re: [GENERAL] Removing languages

От:
Ian Phillips <ian@comodo.net>
Дата:
Definite case of RTFM on my part...

DROP PROCEDURAL LANGUAGE 'plpgsql';

oops 

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
FAQ