November 20th, 2003, 08:29 AM
ERROR: language "plpgsql" does not exist
When I try to create a function with
CREATE FUNCTION x() RETURNS timestamp AS '
' LANGUAGE plpgsql;
I get : ERROR: language "plpgsql" does not exist
I use PG 7.3.1 win32 and I need to "create language plpgsql", but I don't know how?
November 20th, 2003, 09:43 AM
I found it!
sorry, it was all in the documentation!
1. Creata a function handler:
CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler AS
'$libdir/plpgsql' LANGUAGE C;
2. Create the language 'plpgsql'
CREATE TRUSTED LANGUAGE plpgsql
3. ... and I don't know if is a god thing to :
GRANT USAGE ON LANGUAGE plpgsql TO public;
... again, I'm sorry. It was not my intention to abuse this forum.
Last edited by goreXP; November 20th, 2003 at 09:50 AM.