Thanks to Mr Masson for the link to this one.
Apparently I'll be needing to purchase this book soon!
Baby Book Link
Friday, January 11, 2008
Wednesday, January 02, 2008
Installing languages for use in functions in PG DB
I spent a while on this one!
If you are trying to write PL/PGSQL and you can't figure out why your create function is failing with:
...it's because the PL/PGSQL language hasn't yet been installed against your database template.
Run the following command to install into your database....
createlang --username=postgres plpgsql [database]
There are actually heaps of other languages you can choose to use in your database to implement functions/SPs also.
If you are trying to write PL/PGSQL and you can't figure out why your create function is failing with:
ERROR: language "plpgsql" does not exist
...it's because the PL/PGSQL language hasn't yet been installed against your database template.
Run the following command to install into your database....
createlang --username=postgres plpgsql [database]
There are actually heaps of other languages you can choose to use in your database to implement functions/SPs also.
Subscribe to:
Posts (Atom)
