Re: Triggers and Function's

that's problem is mean your postgresql not exist the plpgsql yet, before you
create that function you have to create languange handler for plpgsql
with.....

testdb=>CREATE FUNCTION plpgsql_call_handler () RETURNS OPAQUE AS
'$libdir/plpgsql' LANGUAGE C;

and then.....

testdb=>CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER
plpgsql_call_handler;

best regards.....

Alam Surya

----- Original Message -----
From: "Campos Chaves" <camposchaves(at)yahoo(dot)com(dot)br>
To: "Alam Surya" <alam_surya(at)telkom(dot)net>
Sent: Thursday, May 29, 2003 11:41 PM
Subject: Re: [GENERAL] Triggers and Function's

> See what happened: (It sad that the language is
> wrong!)
>
> Error - /var/www/intranet/phpPgAdmin/sql.php -- Line:
> 112
>
> PostgreSQL said: ERROR: language "plpgsql" does not
> exist
> Your query:
> Create function teste6() returns triggers as'
> begin
> insert into "VERSAO" ( codigo, descricao ) values (1,6
> ) ;
> return;
> end ;'
> language 'plpgsql'
>