debugging techniques - Mailing list pgsql-general

From Klein Balázs
Subject debugging techniques
Date
Msg-id 20051228004333.968172054E76@graveyard2.mail.t-online.hu
Whole thread Raw
In response to Re: Detaching database  ("Petr" <pjsoft@volny.cz>)
List pgsql-general
I am debugging a plpgsql function.
I came from an MSSQL server and I am missing a few techniques here so I
apologize for using MS as my reference.

Is there a variable that stores the number of records the last statement
effected? - in MS it was @@RowCount, I could constantly check its value as I
stepped through the code

Is there a quick way to see a recordset in during the debug (not just the
final recordset) - in MS the debugger always displayed the result of Select
statements so by inserting one I could check intermediary results.

(I am experimenting with EMS SQL Manager now to step through the code).

Thanks.
SWK


pgsql-general by date:

Previous
From: "Pamela"
Date:
Subject: new beginner to postgresql. Looking at it for a church
Next
From: "Dann Corbit"
Date:
Subject: Re: new beginner to postgresql. Looking at it for a church