PostgreSQL for Mac and language support – PLPGSQL

   2009-05-26      Computing · OSX      OS X and languages. · PostgreSQL · saved procedures · stored procedures

Seems sometimes the PostgresqlforMac package doesn’t have support out of the box for PLPGSQL or other stored procedure languages and you can’t simply change to the correct user to upgrade it instead call the createlang command like this: [cc lang=“bash”] /Library/PostgreSQL8/bin/createlang -l DATABASE -U USER; [/cc] Obviously changing DATABASE to your database and USER to your user. This will list all the languages enabled for that database. To add PL/PGSQL, try this:

---