Category Archives: PostgreSQL
Get the PL/pgSQL language working in PostgreSQL
I use the Bitnami LAPPstack on my Linux system to develop my apps. It’s fast, lightweight, and doesn’t get in the way messing up with my system. I start it, restart it, stop it… whenever I want.
One thing it doesn’t have, apart the XDebug extension (I wrote an article on how to get it working: Configure XDebug with Bitnami PHP Stacks on Linux Ubuntu ), is the PL/pgSQL language configured inside the postgresql DBMS. Meaning that if you try to create a stored procedure and a trigger using that language, you’re going to get an error similar to this:
