I am working on my first project with Postgres and there are a couple of stuff I wanted to document:
To install PL/pgSQL which is not installed by default (!), execute the SQL command on your db:
CREATE LANGUAGE plpgsql;Otherwise you will get the error message: "ERROR: language "plpgsql" does not exist" ...
Another surprising missing feature is the inability to connect to other databases. It's not included by default in Postgres but seats in the postgres/contrib project within the funcion dblink.
To install it on ubuntu:
sudo apt-get -y install postgresql-8.2 postgresql-contrib
That's not finished! You have to run the script manually to install it.
psql -U postgres your_database_name < /usr/share/postgresql/8.2/contrib/dblink.sql