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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | S. van der Tol | 1999-10-28 18:01:13 | Problem with initdb |
Previous Message | Ross J. Reedstrom | 1999-10-28 15:10:37 | Re: [GENERAL] pgsql pg_connect |