From: | "Sean Davis" <sdavis2(at)mail(dot)nih(dot)gov> |
---|---|
To: | "Bob" <luckyratfoot(at)gmail(dot)com> |
Cc: | "Craig Bryden" <postgresql(at)bryden(dot)co(dot)za>, "pgsql" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Debugging PL/pgSQL |
Date: | 2005-06-21 21:16:26 |
Message-ID: | 002a01c576a6$7c1448c0$5179f345@WATSON |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Ah, yes.... I should have qualified my statement a bit. Sorry if I was misleading....
Sean
----- Original Message -----
From: Bob
To: Sean Davis
Cc: Craig Bryden ; pgsql
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(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)
From | Date | Subject | |
---|---|---|---|
Next Message | Geoffrey | 2005-06-21 21:41:19 | Re: Making the DB secure |
Previous Message | Tom Lane | 2005-06-21 21:11:05 | Re: startup time |