[Solved] Postgresql New Dll Plpgsql

[gamalielfmb]

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

[Shinryuu]

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

[gamalielfmb]

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.

[Krydos]

Did you drop the database and recreate it?

[gamalielfmb]

yeah, i drop and recreate the DB

and try create the language and the error is the superuser

[Krydos]

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