Re: [GENERAL] Removing languages
От | Ian Phillips |
---|---|
Тема | Re: [GENERAL] Removing languages |
Дата | |
Msg-id | 99102815323902.00677@Gromit обсуждение исходный текст |
Ответ на | Removing languages (Ian Phillips <ian@comodo.net>) |
Список | 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@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
В списке pgsql-general по дате отправления: