Re: Trigger problem

On Fri, 3 May 2002, jquest jquest wrote:

> Hi,
> I am new to postgresql and to this moment I am using oracle.
> I use posgresql 7.1.2
>
> I try to create very simple ( from doc. examples ) trigger:
>
> CREATE FUNCTION add_one (integer) RETURNS INTEGER AS '
> BEGIN
> RETURN $1 + 1;
> END;
> ' LANGUAGE 'pgsql';
>
> But the system report:
> ERROR: Unrecognized language specified in a CREATE FUNCTION: 'pgsql'.
> Recognized languages are sql, C, internal, and created procedural
> languages.
>
> I readet in documentation that pgsql is good solution for SP.
>
> Where is the problem?

You'll want to use 'plpgsql' which is the full name of the procedural
language. If it still fails, it means that createlang was not used on
the database, and you'll want to issue a
createlang plpgsql <database>
as the postgres user from a shell.