pl/pgsql function debugging

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&gt;

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

Remember to vote!

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