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