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 r...@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
