Re: Debug plpgSQL stored procedures

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