I am trying to use the perl language in postgresql, thus I need to install plperl. I am running all of my queries in pgadmin III. When I first tried
create extension plperl; I get the following Error:
could not open extension control file "/usr/share/postgresql/9.2/extension/plperl.control": No such file or directory. SQL state: 58P01
So I tried to install plperl by using the following command in my terminal:
sudo apt-get install postgresql-plperl-9.2 which created a
plperl.control file in the folder
~/9.2/extension/. I ran the create extension again but still received the same error.
I then did a clean uninstall of postgresql and pgadmin III and did a fresh install, but still receive the same error. I am out of ideas on what else I can do. Any ideas?