Re: Track a function

On 14/02/2009 16:34, Carlos Henrique Reimer wrote:

> I've a plpgsql function that when called never ends and I would like to
> trace the internal function commands and see where is the problem.
>
> How can I trace what the function is doing?

You could insert RAISE NOTICE statements into your code, to show where
it is at that point.

You could also try the PL/PGSQL debugger, which comes as a contrib
module - pgAdmin III can act as a client for it,

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------