Re: Unable to create or drop plpgsql

----- Original Message -----
From: "Jason Underdown" <jasonu@xmission.com>
To: <pgsql-general@postgresql.org>
Sent: Friday, June 20, 2003 11:00 PM
Subject: [GENERAL] Unable to create or drop plpgsql


> Hi everyone,
>
> This is my first post to this group, so please be kind.
>
> My database used to have support for plpgsql, that is I used the
createlang
> command line tool to add the language to the database and then added
> functions, and they worked.  Since then I have moved the database to a new
> machine and a new directory (two separate moves).  Now I can't drop the
> language nor create it!  Here is the output when I try to run the
createlang
> and droplang commands.
>
I newer tried to move database on other machine that way, so I do not know
all the konsequences, but it looks to me that you created some kind of mess
with PGDATA and PGLIB directories. PGLIB directory should contain library
with plpgsql. I suggest you to connect to database with psql and try this :

DROP PROCEDURAL LANGUAGE 'plpgsql' CASCADE;

CREATE OR REPLACE FUNCTION plpgsql_call_handler() RETURNS LANGUAGE_HANDLER
AS 'PGLIB/plpgsql.so', 'plpgsql_call_handler' LANGUAGE 'c';

CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER "plpgsql_call_handler"
LANCOMPILER 'PL/pgSQL';

where PGLIB is path to postgres libraryes.
If this fails, post back the error message, so we can see the exact reason
why CREATE LANGUAGE fails.

Regards !