Thread: Debugging PL/pgSQL

Debugging PL/pgSQL

From
"Craig Bryden"
Date:
Hi

Does anyone know of a free SQL Editor that allows you to debug PL/pgSQL
functions?

Thanks
Craig


Re: Debugging PL/pgSQL

From
"Sean Davis"
Date:
You might want to look at pgEdit.

Sean

----- Original Message -----
From: "Craig Bryden" <postgresql@bryden.co.za>
To: "pgsql" <pgsql-general@postgresql.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
>


Re: Debugging PL/pgSQL

From
Bob
Date:
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@mail.nih.gov> wrote:
You might want to look at pgEdit.

Sean

----- Original Message -----
From: "Craig Bryden" < postgresql@bryden.co.za>
To: "pgsql" <pgsql-general@postgresql.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@postgresql.org)

Re: Debugging PL/pgSQL

From
"Sean Davis"
Date:
Ah, yes....  I should have qualified my statement a bit.  Sorry if I was misleading....
 
Sean
 
----- Original Message -----
From: Bob
Sent: Tuesday, June 21, 2005 4:57 PM
Subject: Re: [GENERAL] 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@mail.nih.gov> wrote:
You might want to look at pgEdit.

Sean

----- Original Message -----
From: "Craig Bryden" < postgresql@bryden.co.za>
To: "pgsql" <pgsql-general@postgresql.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@postgresql.org)