Tag Archives: PostreSQL

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:

Posted in PostgreSQL | Tagged , , , , | View Comments