Re: Debugging PL/pgSQL

Keep in mind there is no built in API to debug PL/pgSQL like there is for
PL/SQL. You will have to use the old true and tried output statements to
debug your stored procs.

On 6/21/05, Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> wrote:
>
> You might want to look at pgEdit.
>
> Sean
>
> ----- Original Message -----
> From: "Craig Bryden" <postgresql(at)bryden(dot)co(dot)za>
> To: "pgsql" <pgsql-general(at)postgresql(dot)org>
> Sent: Tuesday, June 21, 2005 3:01 PM
> Subject: [GENERAL] Debugging PL/pgSQL
>
>
> > Hi
> >
> > Does anyone know of a free SQL Editor that allows you to debug PL/pgSQL
> > functions?
> >
> > Thanks
> > Craig
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>