gotik Posted April 20, 2011 Share Posted April 20, 2011 Good Night, I created my functions in postgresql, but these functions need language plpgsql ERROR: language "plpgsql" does not exist HINT: Use CREATE LANGUAGE to load the language into the database. It's possible to create the language?. Thanks for your time. Link to comment Share on other sites More sharing options...
Guest Geoff Posted April 20, 2011 Share Posted April 20, 2011 Moving thread... Link to comment Share on other sites More sharing options...
Guest Geoff Posted April 20, 2011 Share Posted April 20, 2011 I would suggest that you look at the docs: http://www.postgresql.org/docs/8.2/static/...telanguage.html Link to comment Share on other sites More sharing options...
gotik Posted April 20, 2011 Author Share Posted April 20, 2011 yes I know use the command CREATE LANGUAGE plpgsql; but... ERROR: must be superuser to create procedural language Link to comment Share on other sites More sharing options...
Guest Geoff Posted April 20, 2011 Share Posted April 20, 2011 Do you want me to run that command as root? Link to comment Share on other sites More sharing options...
gotik Posted April 21, 2011 Author Share Posted April 21, 2011 Just if it's possible, I'll be very grateful Link to comment Share on other sites More sharing options...
Guest Geoff Posted April 21, 2011 Share Posted April 21, 2011 server? Link to comment Share on other sites More sharing options...
gotik Posted April 21, 2011 Author Share Posted April 21, 2011 Johnny Link to comment Share on other sites More sharing options...
Guest Geoff Posted April 22, 2011 Share Posted April 22, 2011 Escalating request.... @djbob SSH to johnny, run 'psql', and run the following query: CREATE LANGUAGE plpgsql; Link to comment Share on other sites More sharing options...
Ashoat Posted April 22, 2011 Share Posted April 22, 2011 Geoff: Your root privileges are not for running arbitrary commands. Escalate threads on any requests to run commands that you don't entirely, completely understand. gotik: Are you sure you don't want me to run the following? CREATE FUNCTION plpgsql_call_handler () RETURNS OPAQUE AS '/usr/local/pgsql/lib/plpgsql.so' LANGUAGE 'C'; CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER plpgsql_call_handler LANCOMPILER 'PL/pgSQL'; Link to comment Share on other sites More sharing options...
gotik Posted April 22, 2011 Author Share Posted April 22, 2011 Hi djbob, I need just the plpgsql, not C Thanks for your time. Link to comment Share on other sites More sharing options...
Guest Geoff Posted April 22, 2011 Share Posted April 22, 2011 I need just the plpgsql, not C C is the language that /usr/local/pgsql/lib/plpgsql.so is written in. You won't be adding that language to postgreSQL. Link to comment Share on other sites More sharing options...
gotik Posted April 22, 2011 Author Share Posted April 22, 2011 Yep, you are right, I need plpgsql to create my functions. Link to comment Share on other sites More sharing options...
Ashoat Posted April 22, 2011 Share Posted April 22, 2011 Okay, is it working now? Link to comment Share on other sites More sharing options...
gotik Posted April 23, 2011 Author Share Posted April 23, 2011 no :S Error de SQL: ERROR: language "plpgsql" does not exist HINT: Use CREATE LANGUAGE to load the language into the database. Link to comment Share on other sites More sharing options...
Recommended Posts