Database Reference
In-Depth Information
Visual debugging
The PL/pgSQL Debugger is a project hosted on pgFoundry that provides a debug-
ging interface into PostgreSQL Version 8.2 or higher. The following statement is men-
tioned 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 sys-
tem. If you installed PostgreSQL with one of packages that contain the Debugger, in-
stallation is pretty simple. Otherwise, you will need to build it from source.
Building the PL/pgSQL Debugger from source is beyond the scope of this topic. The
best way to build the source would be to pull the latest version for the Concurrent
Versions System ( CVS ) source control system and follow the README file in the
directory. If you want to get started quickly with it, and you have a Windows machine
available, the simplest way to use the Debugger is by using the Windows installer.
Installing pgAdmin3
The PL/pgSQL Debugger module works with pgAdmin3 . There are no special steps
necessary with the installation of pgAdmin3 for the debugger to function. Install it as
usual from your package manager on the platform that you are using. For Ubuntu
10.04 LTS, the following is aptitude:
sudo apt-get install pgadmin3
Search WWH ::




Custom Search