PostgreSQL for Mac and language support – PLPGSQL

         ·      · · ·

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: