-
Our modification requires the PostgreSQL database to have plpgsql language support enabled. Usually, this is enabled by default, but I have come across some installations that don't have this option enabled.
There are two ways to do this, but you have to have superuser access to the database that you want to modify.
1. Running it as a query in PostgreSQLCREATE LANGUAGE plpgsql
2. From the command line (Unix-based environment)createlang -U postgres plpgsql <database>
Where postgres is assumed to be a superuser account, and is the name of the database where you want to have the plpgsql language enabled.
For more information, you can have a look at http://www.postgresql.org/docs/8.1/interactive/sql-createlanguage.html
Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
