Daniel Morgan wrote:
Does PostgreSQL provide a way to step-debug into plpgSQL stored procedures?
Afraid not. One of the commercial versions of PG offered it as a feature
IIRC, but I could be wrong, and if so it was some time ago.
If yes, how do you do debug the stored procedures? Can it be done via
any interface: jdbc, odbc, .net, etc.?
If no, is there any plans to provide debugging support of plpgSQL stored
procedures?
Not afaik - there's plenty of interest, but no-one with enough time and
knowledge I think.
I do request, if you there is plans to add debugging support, make it
easy enough for various interfaces to use it: jdbc, odbc, .net, etc...
That might be tricky as a general case, since I'm not sure all of them
offer a suitable out-of-band channel that could be used to send the
relevant control/debug data. You could always make it part of the SQL
interface, I suppose that would automatically give you cross-client support.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
