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..
|