Re: language "plpgsql" does not exist - Mailing list pgsql-sql

> 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

The problem is, you have not installed the language 'plpgsql'. It can be 
done using createlang command. 

regards,
bhuvaneswaran