Re: Problem with PL/pgSQL

You need to do

CREATE FUNCTION plpgsql_call_handler () RETURNS OPAQUE AS
    '/usr/local/pgsql/lib/plpgsql.so' LANGUAGE 'C';

And :

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


----- Original Message -----
From: "Hans-Jürgen Schönig" <hs@cybertec.at>
To: <pgsql-general@postgresql.org>
Sent: Saturday, February 24, 2001 10:01 AM
Subject: Problem with PL/pgSQL


> What is wrong with the following function?
>
> CREATE FUNCTION logfunc2 (text) RETURNS int AS '
>         DECLARE
>                 text ALIAS FOR $1;
>         BEGIN
>                 SELECT length(text);
>                 RETURN ''3'';
>         END;
> ' LANGUAGE 'plpgsql';
>
> I get the following error:
>
> ERROR:  Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
>
>         Recognized languages are sql, C, internal, and created
> procedural languages.
>
>
> According to my docs "plpgsql" should be ok.
>
>     Hans
>
>