Re: Triggers and Function's - Mailing list pgsql-general

From Alam Surya
Subject Re: Triggers and Function's
Date
Msg-id 002701c32615$37e30760$9b00a8c0@alam
Whole thread Raw
In response to Triggers and Function's  (Campos Chaves <camposchaves@yahoo.com.br>)
List pgsql-general
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'
>



pgsql-general by date:

Previous
From: "Carlos Oliva"
Date:
Subject: FW: Blocking access to the database??
Next
From: Roy Cabaniss
Date:
Subject: Re: exporting join results