Re: language "plpgsql" does not exist

On Friday 23 May 2003 7:48 am, Bruce Young wrote:
> i am trying to create functions only to get the above error in return.
> what do i need to do to get PL/PGSQL functions working?
> example:
>
> CREATE FUNCTION logfunc1(text) RETURNS timestamp AS '
> DECLARE
> logtxt ALIAS FOR $1;
> BEGIN
> INSERT INTO logtable VALUES (logtxt, ''now'');
> RETURN ''now'';
> END;
> ' LANGUAGE plpgsql;
>
> # ERROR: language "plpgsql" does not exist

You need to do a "CREATE LANGUAGE" or use the createlang command-line tool to
enable it in your database:

createlang plpgsql mydatabase

--
Richard Huxton