LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   PL/pgSQL anyone? (https://www.linuxquestions.org/questions/linux-newbie-8/pl-pgsql-anyone-244948/)

vickr1z 10-20-2004 12:58 AM

PL/pgSQL anyone?
 
good day to all.

im installing plpgsql to my postgres database but i have encountered some error.
here's what i did to my interactive postgres terminal:

Code:

polmap=# CREATE FUNCTION plpgsql_call_handler () RETURNS language_handler
polmap--#      AS '$libdir/plpgsql', 'plpgsql_call_handler'
polmap--#      LANGUAGE C;
NOTICE:    ProcedureCreate:  type language_handler is not yet defined
(waiting for sometime.. )
CREATE FUNCTION

polmap=# CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER plpgsql_call_handler
polmap--#      LANCOMPILER 'PL/pgSQL';
ERROR:    CreateProceduralLanguage:    function plpgsql_call_handler must call LANGUAGE_HANDLER

i dont know what this mean. can any body help me how to correct and solve my problem?
thanks in advance..


All times are GMT -5. The time now is 03:16 PM.