Jump to content

Recommended Posts

Posted

dear support

we have rencently installed a Database in your server but we are unable to process some scripts on it written in "plpgsql".

Please advice

my host is surveytest.helioshost.org my server is jhonny

Regards

Posted

This was mentioned in IRC and been installed, it should now be working.

Posted

I have a try again, and actually continuos the same error

 

 

Error de SQL:

ERROR: language "plpgsql" does not exist

HINT: Use CREATE LANGUAGE to load the language into the database

 

best regards.

Posted

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

Guest
This topic is now closed to further replies.
×
×
  • Create New...