Postgres Pro
Downloads
Home   >   mailing lists

Re: Tips on how to efficiently debugging PL/PGSQL - Mailing list pgsql-general

From Glyn Astill
Subject Re: Tips on how to efficiently debugging PL/PGSQL
Date
Msg-id 796557.69933.qm@web23602.mail.ird.yahoo.com
Whole thread Raw
In response to Tips on how to efficiently debugging PL/PGSQL  (<cyw@dls.net>)
List pgsql-general
Tree view 
> From: cyw@dls.net <cyw@dls.net>
> Subject: [GENERAL] Tips on how to efficiently debugging PL/PGSQL
> To: pgsql-general@postgresql.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/

pgsql-general by date:

Previous
From: ries van Twisk
Date:
Subject: Re: Annoying Reply-To
Next
From: Tom Lane
Date:
Subject: Re: Postgres optimizer choosing wrong index