PL/pgSQL

[Guest_imported]

How can I use PL/pgSQL (SQL Procedural Language) ?
Because now I've got following error:

ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.

Recognized languages are sql, C, internal, and created procedural languages.?

 

[rycamor]

You have to run the 'createlang' function. As the user of your database (or as the main 'postgres' user), just run the command 'createlang plpgsql [databasename]', and then you can use PL/pgSQL. -------------------------------------------

"Now, this might cause some discomfort..."
(

http://www.wired.com/news/politics/0,1283,51274,00.html)