gamalielfmb Posted April 15, 2013 Posted April 15, 2013 dear supportwe have rencently installed a Database in your server but we are unable to process some scripts on it written in "plpgsql".Please advicemy host is surveytest.helioshost.org my server is jhonnyRegards
Shinryuu Posted April 15, 2013 Posted April 15, 2013 This was mentioned in IRC and been installed, it should now be working.
gamalielfmb Posted April 15, 2013 Author Posted April 15, 2013 I have a try again, and actually continuos the same error Error de SQL: ERROR: language "plpgsql" does not existHINT: Use CREATE LANGUAGE to load the language into the database best regards.
gamalielfmb Posted April 16, 2013 Author Posted April 16, 2013 yeah, i drop and recreate the DBand try create the language and the error is the superuser
Krydos Posted April 17, 2013 Posted April 17, 2013 => SELECT COUNT(*) FROM pg_language WHERE lanname = 'plpgsql'; count ------- 1 (1 row) It sure looks like it's already installed to me. Like I said, if you aren't able to use plpgsql you just need to drop the database, and recreate it. Here is the results of the same query on a database that I created before I installed plpgsql on Johnny. It hasn't been dropped and recreated: => SELECT COUNT(*) FROM pg_language WHERE lanname = 'plpgsql'; count ------- 0 (1 row) I think your confusion is from using the wrong command. You don't need to create the language because only superuser privileges can do that, and the language is already created. You just need to use create the function in the language plpgsql.
Recommended Posts