Thread: pl/pgsql function debugging

pl/pgsql function debugging

From
"Craig"
Date:
Hi
 
What is the best tool for debugging pl/pgsql functions?
Any suggestions would be appreciated
 
Thanks
Craig

Re: pl/pgsql function debugging

From
David Fetter
Date:
On Thu, Sep 29, 2005 at 08:08:17PM +0200, Craig wrote:
> Hi
>
> What is the best tool for debugging pl/pgsql functions?  Any
> suggestions would be appreciated

For now, it's RAISE NOTICE aka "debugging by printf", and  I'm
checking out EMS HiTech's debugger, which is part of their toolset.

<http://sqlmanager.net/en/products/postgresql/manager>

Cheers,
D
--
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!

Re: pl/pgsql function debugging

From
"A. Kretschmer"
Date:
am  29.09.2005, um 20:08:17 +0200 mailte Craig folgendes:
> Hi
>
> What is the best tool for debugging pl/pgsql functions?
> Any suggestions would be appreciated

RAISE NOTICE 'foo %', bar;

Read: http://www.postgresql.org/docs/8.0/static/plpgsql-structure.html

Regards, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===