Postgres Pro
Downloads
Home   >   mailing lists

Thread: Trigger problem

Trigger problem

From
"jquest jquest"
Date:
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?

Many thanks in advance.

_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com

Re: Trigger problem

From
Stephan Szabo
Date:
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.

Re: Trigger problem

From
Aaron Spiteri
Date:
In postgres you the plsql equivalent is 'plpgsql' not 'plsql'.

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 3/05/02, 21:17:38, "jquest jquest" <jquest_j@hotmail.com> wrote
regarding [ADMIN] Trigger problem:


> 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?

> Many thanks in advance.

> _________________________________________________________________
> Send and receive Hotmail on your mobile device: http://mobile.msn.com


> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)