O'Reilly logo

PostgreSQL Server Programming by Jim Mlodgenski, Kirk Roybal, Hannu Krosing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Visual debugging

The PL/pgSQL Debugger is a project hosted on pgFoundry that provides a debugging interface into PostgreSQL Version 8.2 or higher. The following statement is mentioned at http://pgfoundry.org/projects/edb-debugger/:

"The PL/pgSQL debugger lets you step through PL/pgSQL code, set and clear breakpoints, view and modify variables, and walk through the call stack. "

As you can see from the description, the PL/pgSQL Debugger can be quite a handy little tool to have in your arsenal.

Getting the debugger installed

Ok, now we move past the glamour, and need to actually get it running on your system. If you installed PostgreSQL with one of packages that contain the Debugger, installation is pretty simple. Otherwise, you will need to build it ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required