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@yahoo.com.br>
To: "Alam Surya" <alam_surya@telkom.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'
>