Re: Track a function

Carlos Henrique Reimer <carlos(dot)reimer(at)opendb(dot)com(dot)br> schrieb:

> Hi,
>
> 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 can use RAISE NOTICE 'i'm here %', variable;

to display where the function is and also the content of variables.

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°