Re: [GENERAL] Iis there anyway to do this(see in message)

2005-01-17 Thread Tony Caduto
Michael, Thank you for the info, it actually should give me enough detail, though not as convienent as a trace tool would be. People request a trace feature for PL/pgSQL from time to time but I don't think anybody has implemented it yet. I'm sure a patch would be welcome Would love to hel

Re: [GENERAL] Iis there anyway to do this(see in message)

2005-01-16 Thread Madison Kelly
Tony Caduto wrote: Hi, Just wondering if there is a way to monitor the SQL that is executed inside a PL/pgsql function? I can see some SQL via the stats view, but it does not show the sql that is being executed in a function. The reason I ask is it would make debugging large complex functions muc

Re: [GENERAL] Iis there anyway to do this(see in message)

2005-01-16 Thread Michael Fuhr
On Sun, Jan 16, 2005 at 07:00:42PM -0600, Tony Caduto wrote: > Just wondering if there is a way to monitor the SQL that is executed > inside a PL/pgsql function? > I can see some SQL via the stats view, but it does not show the sql that > is being executed in a function. You can get some loggin

[GENERAL] Iis there anyway to do this(see in message)

2005-01-16 Thread Tony Caduto
Hi, Just wondering if there is a way to monitor the SQL that is executed inside a PL/pgsql function? I can see some SQL via the stats view, but it does not show the sql that is being executed in a function. The reason I ask is it would make debugging large complex functions much easier. I get a