can't install PL\PgSQL language
Posted on 2004-11-11
here is the problem: i tried to run an sql script against my PostgreSQL database and i get this error:
$ psql -d mydbname -h myhost.something.edu -U lvassilev < test.sql
ERROR: language "plpgsql" does not exist
HINT: You need to use "createlang" to load the language into the database.
So i am guessing i need to install the "plpgsql" language in my PostgreSQL db. so i do this:
$ createlang plpgsql -d mydbname -h myhost.something.edu -U lvassilev
createlang: language installation failed: ERROR: permission denied for language
i guess that means i don't have permission to do this. I am not a superuser on this database, i just log in to it remotely as a regular user. Does that mean i need to ask my DBA to do it for me or what?
i am logging to PostgreSQL through CygWin command prompt on a Windows XP professional machine.