Re: Has anyone tried out the PL/pgSQL debugger?

korry.douglas wrote:
>> Don't see the tracer, unless I'm missing what you mean.
> You're right, it's not in the edb-debugger tarball.  If you think you 
> might be interested, I can resurrect it.

Hmm - it's not that the plpgsql I write has complex control-flows, but 
it might prove useful to others.

>> Problem with RAISE DEBUGs throughout my plpgsql is that it's either 
>> all on or all off. I'd like something more controllable.
> How about a PL/pgSQL function such as LOG_MESSAGE( message TEXT, level 
> ENUM, facility ENUM )?  Just a thought...

I do, but then comment them out when not testing. Perhaps I'm optimising 
prematurely though. I'll have to run some timing tests...

--   Richard Huxton  Archonet Ltd