PostgreSQL Discussion - pl/pgsql function debugging

Author

pl/pgsql function debugging

Craig

2005-09-29, 1:23 pm

Hi

What is the best tool for debugging pl/pgsql functions?
Any suggestions would be appreciated

Thanks
Craig

David Fetter

2005-09-29, 8:23 pm

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!

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

A. Kretschmer

2005-09-29, 8:23 pm

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/...-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 ===

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Sponsored Links