> From: cyw(at)dls(dot)net <cyw(at)dls(dot)net>
> Subject: [GENERAL] Tips on how to efficiently debugging PL/PGSQL
> To: pgsql-general(at)postgresql(dot)org
> Date: Thursday, 23 October, 2008, 6:19 PM
> Just to seek some tips on how to efficiently debug PL/SQL.
>
> One thing that bugs me in particular is the inability to
> trace a SQL line
> number in an error message to the line in my PL/PGSQL code.
>
edb have a debugger that intigrates with pgadmin
http://pgfoundry.org/projects/edb-debugger/