Mostly because I didn't need them, and hadn't had any requests, though, plpgsql is now included and can be enabled running:
su -m postgres -c '/Library/PostgreSQL8/bin/createlang plpgsql template1'
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Is there a reason common languages isn't included in the package? (eg. plpgsql ) Or have I just been unable to find it?
Mostly because I didn't need them, and hadn't had any requests, though, plpgsql is now included and can be enabled running:
su -m postgres -c '/Library/PostgreSQL8/bin/createlang plpgsql template1'
That's what I tried to do. but I only gegt a error message:ERROR: could not access file "$libdir/plpgsql": No such file or directory
I've tried searching but the only files in /Library/PostgreSQL8 that seems related to plpgsql is in doc...
Looks like a bug. Which version of the installer did you use ?
I used the 8.0.2a package.
I had the same problem with a 8.0.1 package. (Not sure if it was b or c)
I'm going to refile this as a bug, let's get it resolved for 8.0.2b. Any other languages you think we need ?
It would be nice if all the languages mentioned in the manual came with the package. That would be pl/pgsql pl/tcl pl/perl pl/python
That way people (like me) don't get confused when things covered in the manual is missing. I'm not sure how much work this is, though.