Re: Track a function - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: Track a function
Date
Msg-id 4996F6A4.7080106@iol.ie
Whole thread Raw
In response to Track a function  (Carlos Henrique Reimer <carlos.reimer@opendb.com.br>)
List pgsql-general
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@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Track a function
Next
From: "Ken Winter"
Date:
Subject: Problem with non-unique constraint names