Archive for July, 2010
ERROR: language “plpgsql” does not exist
July 15, 2010
Leave a comment
When I try to create a function with
CREATE FUNCTION x() RETURNS timestamp AS ‘
<function boddy>
‘ 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?
Use the below commands to create a language for a specific Database.
createlang -l
createlang -d dbname plpgsql
Other options are: –
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
HANDLER "plpgsql_call_handler";
GRANT USAGE ON LANGUAGE plpgsql TO public;
Categories: PostgreSQL
postgres