Re: Triggers and Function's
От | Alam Surya |
---|---|
Тема | Re: Triggers and Function's |
Дата | |
Msg-id | 002701c32615$37e30760$9b00a8c0@alam обсуждение исходный текст |
Ответ на | Triggers and Function's (Campos Chaves <camposchaves@yahoo.com.br>) |
Список | 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 по дате отправления: